Query A Table That Stores Records From Other Tables

[SeaTigr]

Good day all,

I've been trying to solve this problem, but I just can't seem to come up with the correct verbiage to make my Googling easier.

So,

I've created an inventory database. Users utilize a form to enter new equipment into the database or modify existing records. The form has combo boxes for several items, such as unit type (Laptop, Workstation, Server, Monitor, etc.) and system name (the name of the program which owns the equipment). I use combo boxes to mitigate user errors in spelling and punctuation that will make queries more difficult. The main inventory table stores the comb box selections as numbers, referencing the ID of the selection on the table which contains the list.



With the equipment table query, I would like users to be able to enter the system name. Currently, they must enter the ID#. How do I do this?

I've included a screenshot, with some identifying names and numbers removed.

[R_Badger]

You are better off doing this sort of thing on a form as rule.

I generally say, tables and queries for you, forms and reports for users.

Set the table as the recordsource on the form, then with the combobox set your rowsource but do something sneaky, set it to two columns, first being 0cm wide

i.e
Row source

Column 1 Column2
SystemID System Name

Because the first column is hidden by being 0cm wide, they are entering the ID but seeing the text.

Hope that makes sense.

[SeaTigr]

Thank you, that helped a lot. My apologies on the delay...got one of those "drop everything you're doing" projects.