Storing an Id in multiple tables

[Guest]

I have a database that has two tables, Leases and Payment History. I need
the Autonumber "Lease Id" to store as a new record under a field "Lease Id"
in the Payment History table(thereby creating a new payment Id).

 

[Douglas J. Steele]

That's not a recommended approach.

There's no point saving a dummy record in the Payment History table. Don't
create the new record until you have something to store in it.

 

[John W. Vinson]

I have a database that has two tables, Leases and Payment History. I need
the Autonumber "Lease Id" to store as a new record under a field "Lease Id"
in the Payment History table(thereby creating a new payment Id).

Don't bother. Instead, just have the Payments table contain a Long Integer
LeaseID field, and use a Form based on the Leases table with a subform based
on the Payments table; use the LeaseID as the master/child link field.

A new record will be created which will automatically inherit the lease ID at
the moment that data is entered on the subform. You don't need a pre-existing
record.

John W. Vinson [MVP]