append to multiple linked tables

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top