Hi,
I''m working on a project currently where the user must enter data that is placed into a background Access Database. I made the data adapter and the data set of the table being used. I also use the dataset as the datasource for my datagrid. The problem is that a particular column in the dataset is a foreign key to another table and must be constantly set to a specific value that must not be tampered with in order to keep the relationship for updates. Is there a way to easily make specific columns in this datagrid read-only? And also is there some way to set the default value of a particular cell to a preset variable value? (Variable because the foreign key used in this table has to match an autonumber key from the parent table.)
