Solved How to insert data at one go in both the parent table and child table in Microsoft Access (1 Viewer)

quite frankly your code does not make sense as written
To underline the content:
INSERT INTO [tblJobWorks]
- versus -
NewID = DLast("ID", "tblJobcosting")

How does tblJobWorks write to tblJobcosting so that something usable can be read from tblJobcosting?

Think before coding.
 
If you're going to use an unreliable method instead of @@Identity, at least use DMax() rather than DLast()
 
Many thanks Minty this will help alot
 

Users who are viewing this thread

Back
Top Bottom