I'm trying to create a multiply table (SQL) datagrid which updates fields in the primary table. The primary table holds diluted information such as a colour id, e.g. colour id for black is 5, on the datagrid it must show BLACK. In this case the primary table is linked to the colour table to get the actual colour.
When I configure the dataset I get the error for Update & Delete "Could not determine which column uniquely identify the rows for 'table name'
When I configure the dataset I get the error for Update & Delete "Could not determine which column uniquely identify the rows for 'table name'