question on updating a 3rd - intermediate table using forms

[glars]

for simplicity, i have 2 tables:
- parts_tbl ( parts_id, parts_name )
- acct_tbl ( acct_id, acct_name )
here, parts_id & acct_id are primary keys.

the 2 tables have a many-to-many relation. consequently, i use a 3rd intermediate table:
- p-a_tbl ( p-a_id, parts_id, acct_id )
here, p-a_id is a primary key and i established unique ( parts_id, acct_id ).

currently, i have setup the parts_tbl as the mainform and the p-a_tbl as the subform. i also have added the acct_tbl as a 2nd mainform in the form via the form navigator.
consequently, i can select a parts_tbl.parts_name and have the p-a_tbl.parts_id automatically established. in addtion, i select an acct_tbl.acct_name to identify the associated acct_tbl.acct_id and then manually enter this into the p-a_tbl.acct_id.

although this works, it is overly complicated for the nominal user - 1) the manual step is a potential source of error during entry, 2) the p-a_tbl should really be hidden from the user.

so, my questions are associated with these 2 issues:
1) is there a way to modify my approach to permit the user to select acct_tbl.acct_name and have the p-a_tbl.acct_id updated automatically rather than manually?
2) is it possible to display only the parts_tbl.parts_name and acct_tbl.acct_name and then, on acceptance of the entries, have the components of the p-a_tbl table filled in.

[Brivot]

Only solution I found was to create a request :

Req = parts + accts fields

this shows up into p-a_tbl.acct only when "someting new" is entered into p-a_tbl.acct.

To get around this pb, I added a binary field called parts_tbl .registed. When the user clicks on a checkbox called "selected", the reccord is selected and goes into the request.

Sorry, not able to help more.

mdb

[Voobase]