Hello All,
I think I am missing a fundamental command needed when updating records in auxiliary tables which link to the main tables used in my Customers and Orders forms, and the Shipping Addresses subform. After entering shipping address data or selecting a shipping address, and attempting to save the Order record there are two errors:
When I force a close and check the Orders, I can see that a record was added, however something isn't right because the Invoice numbering sequence is not updating (shows "00000" in below image).
Any guidance is appreciated.
Thank you,