Hey everyone,

I'm working on this system that requires 3 tables. The tables essentially create a chain. That is, the first table has a FK to the second(1 to many), and the second has a FK to the third(1 to 1). The problem I'm running into is trying to find a good way to insert the data. I've got the PKs of the 2nd and 3rd tables set to Autonumber (I'm using Access, which is why I'm posting here), but I don't know if there's a way to figure out what the value of the autonumber during the insertion of the records. Because of this, the only way I can think of right now is to insert everything in a backwards fashion, but this would generally be a real pain.

Does anyone have any ideas?


PS--If what I said doesn't made any sense, let me know and I'll upload the ERD.