New. So I dont know the right words for what I'm asking.

[akedm]

Hi,

This may be why I do not know how to find what I want.

I have two tables: Employees, and Devices. One table of employees and their ID, and another table of devices and their ID. The purpose of the database is to link employees to the devices they use. For example, employee ID 15 is using device ID A10. It's more of a object exercise, but the idea is I'm linking devices to employees.

Ok so I got all this set up and a form ready. What I want is to have the form display the name of the employee and device when I type in the ID for each, as like a confirmation: I type in 15 and the name "Jack Smith" pops up. I type in A10 and the device name "Company Laptop" comes up.

As you can tell, I do not know the terms for what I'm asking. I'm in Form Design > Controls. I assume what I need is in this section. What do I do next.

Thanks.

[pbaldy]

If you use a combo box you can have both pieces of information displaying. User would select the ID and you can view the description:

https://www.baldyweb.com/Autofill.htm

You may need another table, unless and employee can only have a single device. I guess you could have an employee ID field in the devices table presuming a device can only be linked to a single employee.

[akedm]

Cool. Thank you. I did come across a combo-box instructional, but being new I just didnt see how "combo-box" equated to "display field" and thought I was in the wrong section. You know. I'll look at that again.

[pbaldy]

No problem, and welcome to the forum by the way!

A combo is nice because you can limit the user's entry to legitimate choices, rather than allowing free entry in a textbox.