Originally Posted by
June7
You do have lookups built in the table. Open Orders table in design view. Select Equipment Items field. This field is set as Number type which means you must save a number value, not descriptive text. Click the Lookup tab. It is set for a listbox with a RowSource that has an alias. By alias I mean the table shows the descriptive text but is saving the ID. With this arrangement must use the second option described in post 2.
Also, the subform container SourceObject is the Orders table, not the Orders form. Except for Data Macros, cannot have code behind tables.
BTW, advise no spaces or special characters/punctuation (underscore is exception) in naming convention.