The UniqueIdentifier as an Index Field
I'm trying to creat a Form that can display and add records to a simple table with it's primary Key defined as a uniqueIdentifier type and the default value in that field is set to NewID().
I've created a Form, added a Dataset, Binding Control, and Binding Navigator, and 2 TextBoxes to display First and Last Name fields (unique field is not shown)
I've set up all the data objects correctly to the point were the Form Builds without errors and displays the data in the DB file, I can navigate through the data without incident.
I of course get an error when I try to add a new field because the UniqueIDentifier does not allow Nulls, and the auto generated code is trying to add all the fields in the definition to the new Row.
I suppose I could just alter the DataSet to not Select the uniqueIdentifier field, however I eventually want to set up a relationship so the field will be required.
Any advice on how I can make this work ?
