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

0 votes

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.

in How To by (7.0k points)

1 Answer

0 votes
Best answer

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.

by (64.4k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer