Can't Insert a record with an automatically incremented key.

Question

I have a field that is a key so it is required. When I create a new record the key field is automatically incremented behind the scenes if I don't display it in the form fields. If I display it in the form fields then I have to manually enter it and have no idea what the next value should be. If I don't display it in form fields then I cannot change the record since it say's the field can't be null when I try the update.

Answer 1

If dbFront detects that the field will automatically increment then dbFront will mark the field as read-only with the expectation that the database will return the new value.

Please ensure that the field is marked as read-only in dbFront on the field preferences.