Using ID field to select linked table record

[Xfree]

I have two tables linked table one is parts table two is shipping. When I
create a new shipping record I want to select the part number from the part
table. I am linked using the primary field in the parts table to a matching
non-primary field in shipping. I can see and select a part record from the ID
table in parts but I want to select the record by listing the part number.

If my question did not make sense let me know I will try to explain better.

 

[Douglas J. Steele]

Hopefully you're not working directly with the tables.

Create a form, add a combobox that lists the part numbers, with the primary
field of the part table as its bound field, and bind that control to the
appropriate field in your shipping table.

 

[Xfree]

Hello Douglas,
Yes I was trying to do it directly with the tables but I have started over
with your suggestion and all is good until I get to the last screen while
setting up the combo box. Do I want Access to Remember the value for later
use or Store that value in this field. Once I create this new record I want
the part number I select to stay with that record so I am thinking I would
select store that value in this field; is that correct?

And thank you for the help.