MS Access SQL Insert data into table with relationship -

i have been searching everywhere solution problem , have concluded may asking wrong question. hoping here can answer question or tell me right question ask.

i have 2 tables estimates , takeoffsheet:

    +----------------------+  +----------------------+     |   estimates          |  |  takeoffsheet        |     +----------------------+  +----------------------+     | 1. estimate_id = pk  |  | 1. sheet_id = pk     |     | 2. number            |  | 2. estimate_id = fk  |     | 3. estimate_name     |  | 3. sheet_name        |     +----------------------+  +----------------------+ 

i trying insert new row in takeoffsheet estimate.number=something. there relationship defined between takeoffsheet , estimates dont know how insert new row in takeoffsheet, estimate_id estimates. @ least not in 1 sql statement.

i know can in multiple steps (first estimate_id, add new sheet that) rather in single statement if possible. there "join" type of insert in ms access?

thanks help!

if defined foreing keys, , created view e.g. v_takeoffsheet able append records per sql like

insert v_takeoffsheet (sheet_name,[number],estimate_name) values ('sheet1',1,'est1'); 

access set estimate_id record fitting in number , estimate_name, if record not existing created , new estimate_id used in takeoffsheet .