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.