Autonumber

[RycherX]

I have two tables: Master_Transaction & Transaction_Detail; this is a one to many relationship.
When a new row is added to Master_Transaction, the autonumber field creates a unique identifier.

Immediately after Master_Transaction gets updated, I would like to retrieve that new unique identifier and add it into Transaction_Detail.

Is there a way to do this?

 

[georgedwilkinson]

Then I take it you're not using bound forms?

 

[RycherX]

Then I take it you're not using bound forms?

I do have a form bound to the Transaction_Detail table.
Can you bound two forms? Ideally, I'd like to update two tables at the same time using a unique identifier.

 

[John Big Booty]

Have a look at Forms and Subforms. From what you have said thus far I suspect it may be what you are looking for.

 

[georgedwilkinson]

Agreed. You don't need to know the main form's ID to populate the sub-form's records automatically.

 

[Rabbie]

I do have a form bound to the Transaction_Detail table.
Can you bound two forms? Ideally, I'd like to update two tables at the same time using a unique identifier.

Just base your form on a query that has dat from the two linked tables