Bound Cloumns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Question 5
Combo box source 8
Date overlap***UP*** 1
validation dependencies 1
Form bound to more than one table, need to update and delete. Dlo 1
referring to a field in a datasheet form 3
Question about Scheduling Database Table Days of the Week 1
Find employees within a stated period 3

Back
Top