Look up

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

Guest

I have two tables. Main table has primary key, surname, firstname, plus some other stuff. Data table has a look up field to get the surname and firstname, plus a primary key (because duplicates are allowed). When trying to select the name in the Data table, it shows only the number. This is understandable, as the look up field has defaulted to a numeric data type. I want to both see and display just the surname and firstname. What am I doing wrong please? The bound colums = 1, the column count = 3 (0cm;2.54cm;2.54cm). Have fiddled around with these to no avail. Would be very grateful for your help. Thanks.
 
Wizards, wizards!

Hi

If you have a main table and a look-up table as such, in the main table use a look-up wizard as your data type. It will allow you to select mutiple fields if you so choose for your look-up

Really do't trouble yourself with the hassles of doing it any other way..

Good luck!
 
I have two tables. Main table has primary key, surname, firstname, plus some other stuff. Data table has a look up field to get the surname and firstname, plus a primary key (because duplicates are allowed). When trying to select the name in the Data table, it shows only the number. This is understandable, as the look up field has defaulted to a numeric data type. I want to both see and display just the surname and firstname. What am I doing wrong please? The bound colums = 1, the column count = 3 (0cm;2.54cm;2.54cm). Have fiddled around with these to no avail. Would be very grateful for your help. Thanks.
Click to expand...

Well... I'm going to be annoying here, because I'm going to have to
say This Is The Wrong Question.

Table lookup fields are EXTREMELY limited in scope, and generally
should not be used *AT ALL*. See

http://www.mvps.org/access/lookupfields.htm

for a critique.

Instead, use a Form. You can use exactly this combo box on the Form,
and put two textboxes next to it, with control sources

=comboboxname.Column(1)
=comboboxname.Column(2)

to display the second and third (it's zero based) columns of the
combo.
 
Thanks David - I failed to mention that I had already done that, and still had problems.
 
Back
Top