I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.
You can customize your Microsoft Access database by calculating values, setting search criteria and formatting data fields with expressions. Syntax is the kind of information and order of information ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback