I am embarrassed to ask this, but I am not sure of the best way to handle this issue. I create a two table (parent-child) dataset and assign that to a DevEx XtraGrid datasource. The grid shows the records in a hierarchy view (can expand the parent to see the child recs) so I need the primary key in the dataset for the first table because that is part of the relationship, but of course I don't show it in the grid. When the user creates a new row, the primary key (identity field) requires a value, which of course has has to be unique in the dataset. I can set up the column to be incremented and that would work great if there was an easy way to determine the max value in the column. Got any ideas about this?
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
