S
Sharon
Is there a way to have more than one bound column in a combo box?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Klatuu
No.
What is it you are trying to do? Perhaps we can offer a suggestion.
What is it you are trying to do? Perhaps we can offer a suggestion.
F
fredg
Is there a way to have more than one bound column in a combo box?
No.
Now if you tell us why you think you need more than one bound column,
perhaps some one can help with an alternative solution.
S
Sharon
Example:
Table: Employee Table - Field :Employee No Field: Employee Company
When using the pull down in a form the employee No saves as the bound entry,
but I would also like the employee co from that table to save.
Table: Employee Table - Field :Employee No Field: Employee Company
When using the pull down in a form the employee No saves as the bound entry,
but I would also like the employee co from that table to save.
F
fredg
Example:
Table: Employee Table - Field :Employee No Field: Employee Company
When using the pull down in a form the employee No saves as the bound entry,
but I would also like the employee co from that table to save.
Why? As long as you have saved the Employee Number field, any time you
need to show the Name associated with the number, you could:
1) Use DLookUp() to find the name.
=DLookUp("[EmployeeName]","EmployeeTable","[EmployeeNumber] = " &
[EmployeeNumber])
or..
2) Setting a relationship between the Employee table EmployeeID and
the main table EmployeeID, in a query, simply drag the Name field onto
the grid..
There is no need to store both fields.