Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...
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 ...
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.