M
MTK
I currently have 2 linked tables for a scholarships type database: Funding
Allocations, and Installments. They are joined by an ID that is generated in
the Funding Allocations table as an autonumber, it is the primary key in each
table. Manually, data can be entered first into the Funding Allocaitons
table, the ID is generated, then in the Installments table it becomes a
lookup field to enter the remianing data (ie. installment date, installment
amount, etc.). I typically do this using a form as well that populates both
tables at once.
However, on a regular basis I have a batch of data to enter. I thought I
would do this with an append query. Adding the data to the Funding
Allocations table is easy enough and then it generates the IDs automatically,
but then how do I poplulate the Installments table as well with the newly
genearted IDs?
Allocations, and Installments. They are joined by an ID that is generated in
the Funding Allocations table as an autonumber, it is the primary key in each
table. Manually, data can be entered first into the Funding Allocaitons
table, the ID is generated, then in the Installments table it becomes a
lookup field to enter the remianing data (ie. installment date, installment
amount, etc.). I typically do this using a form as well that populates both
tables at once.
However, on a regular basis I have a batch of data to enter. I thought I
would do this with an append query. Adding the data to the Funding
Allocations table is easy enough and then it generates the IDs automatically,
but then how do I poplulate the Installments table as well with the newly
genearted IDs?