I will second Moke123 about the Look up FIELDS.... Here are a couple of articles as to the reason why
The Evils of Lookup Fields in Tables and
Issues with Table Level Lookup Fields
Also, "Name" is a reserved word in Access and shouldn't be used as an object name. Problem names and reserved words in Access
Note: I changed your table/field names
I have 2 tables. Parent and Child.
Not to nitpick, but I have never heard of a Parent or Child table. You can have 2 or more tables that are related, but that does not make either one a Parent or child.
On a FORM that has a record source of "tblPrinters" or a query based on table "tblPrinters", you would have a combo box control bound to the field "PrintOrientation_FK". with a Row source of
Code:
SELECT tblPrintOrientation.OrientationID_PK, tblPrintOrientation.Orientation
FROM tblPrintOrientation
ORDER BY tblPrintOrientation.Orientation;
Set the
Column Count : 2
Column Widths : 0
Or, since the options are limited/stable for orientations, you could set the combo box Row Source Type to "Value List" and type in the orientations for the Row Source.
OK, I'll get off my soapbox now. No offense meant for you..... just a little venting.