Bound Cloumns

R

Ray

Good morning:

I have two tables (Employee, Main) where i am attempting to setup drop down
menus that allow me to view two columns from the "Employee" table in the
"Main" table. I set both boxes up using the "Lookup" fields: Bound Cloumn set
to 0 for EmployeeName, Bound Column set to 1 for the EmployeeSSN with the
LimitListTo field set to "Yes"; however, i am still seeing only one column
"EmployeeName" in both drop down fields. Any assistance would be greatly
appreciated.

Thanks,
Ray
 
J

James Goodman

You should not be attempting to view store data from two columns from one
table, in two columns in another table.

A single employee has a single name, & a single SSN? This being so, store
only the employee's employee id in the main table. Select the employeeID,
name & SSN columns as sources for the employeeID column in the main table.
Then set the ColumnCount to 3 & the bound column to 0. Set the columns
widths to 0,5,5 so that only the name & SSN are displayed.
 
Top