I have a table with your standard Update window and procedure that works fine. When a new record is created, the ID field is incremented by one in the new record automatically.
Now I have some Embedded code trying to create a new record manually in the same table:
TABLE1:Field1 = TABLE2:Field1
I'm not specifying the TABLE:ID field assuming the system would increment the value automatically. But, the new record is created and the assigned values are saved to each field -- except the ID field which is always 0.
I'm now assuming I have to specify TABLE:ID = -- but to what?