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

[ebs17]

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.

 

[Pat Hartman]

If you're going to use an unreliable method instead of @@Identity, at least use DMax() rather than DLast()

 

[nector]

Many thanks Minty this will help alot