Ok, I hope I am asking this question correctly ...
1) I have multiple tables in a database
2) I need to associate records in one table in a one to one relationship to the other
3) I don't want to update the first table, only the second.
The reason for this is I need to have users enter a rank for the records and not be able to edit the records.
For example, there are 100 records in Table1, the user needs to rank each of these records from 1 to 100 and the values need to be stored for future use.
Since I will have many people ranking the records, I don't want to add a field to the record for each person, in fact, it would soon exceed the capabilities of access.
Is there a way that I can read a specific column from table1 into a dataset in .net then add another column for the rank, display that data in a datagridview, then update table2 with the result?
1) I have multiple tables in a database
2) I need to associate records in one table in a one to one relationship to the other
3) I don't want to update the first table, only the second.
The reason for this is I need to have users enter a rank for the records and not be able to edit the records.
For example, there are 100 records in Table1, the user needs to rank each of these records from 1 to 100 and the values need to be stored for future use.
Since I will have many people ranking the records, I don't want to add a field to the record for each person, in fact, it would soon exceed the capabilities of access.
Is there a way that I can read a specific column from table1 into a dataset in .net then add another column for the rank, display that data in a datagridview, then update table2 with the result?
