AndrewZ Moderator


Joined: 21 Jun 2004 Posts: 4140 Location: Colorado, USA
|
Posted: Fri Jul 01, 2005 2:56 pm Post subject: probably easy: populate list box with data from other table |
|
|
Say I have tables called Contacts and Employees. The table for Contacts has a field called assigned_employee_id (integer) that refers to a row in Employees.
In a form for Contacts, how do I setup a list box populated with list of names from Employees? The form displays the names of the employees, but it stores the emloyee's primary key in the Contacts table.
I am looking at List Box Properties: Data. Would I use a table? If so, what is "bound field"? Why are "bound field" options given as numbers, not field names in the specified table?
 |
|