Insert into one to many, PK and FK insert

I have a normalized DB with one to many relationships, using Primary and Foreign Keys.



I need to do inserts and maintain the PK/FK relationship, which means when I add a new PK I need to insert that PK as FK in other tables in the same transaction.



How do I do this in Access? SQL Server I use transactions, but I can't lock up the tables in Access like that.



I did a bunch of searching and found nothing, which leads me to believe I am way off in my thinking. Below are the dirty details



I have 2 tables, tblName and tblPhone. 1 name can have many phones.



tblName has PKName. tblPhone has PKPhone, FKName.



I have a form where user enters a new Name and PhoneNumber.



Name gets inserted to tblName, assigned with PKName = 100



Phone should get inserted into tblPhone with PKName.



IE Insert into tblPhone (FKName, PhoneNum) VALUES (100,"212-555-1212").



The dumb way I am doing it now is I insert to tblName, query tblname for the PK, then write to tblPhone. This can't be right.



Thanks!!

Insert into one to many, PK and FK insert