Some advice please.  I'm designing an Access dB which uses 7 tables that have relationships defined.  The primary key is the autonumber field.  I've designed the GUI and the Add Member form in ASP which successfully adds a new member to the dB.  The related tables contain data associated with each member e.g. Training courses completed, Qualifications etc.  Most tables are one-to-one relationships but one is one-to-many which will hold recurring records of the member's yearly membership payments with associated details e.g. receipt number, date paid etc.

 

Now, not having any experience in dealing with more than one table before, what is the recommended practice for adding records to the related tables for a member.  I assume I need to take the autonumber key from the Member's Table and add it to the key field in the new record located in the related table so the relational link is created?

 

I hope this makes sense, otherwise I'm on the wrong track!

 

Any tips would be appreciated.  All code examples I've found focus on using just one table which is relatively straight forward.  I can't seem to find any leads to code that use multiple related tables.  I've tried searching through the WWF code but it gets too confusing .

 

Cheers,

Roman