Look Up Tables

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

Can I use the same Lookup Table to look the same
information twice - for 2 different fields. Ex:
Look up an employee ID number for a field called [ID1] and
then again for a field called [ID2]. Both fields using
the same Lookup Table called [EmpID]. I am having a
problem with this. When I created the two look up fields,
I got a message with the 2nd field to tell me that I had
already used that field.

Aurora
 
Aurora,
Please show us the Dlookup code you're trying to use.

Also, you wrote...
When I created the two look up fields, I got a message with the 2nd field
to tell me that I had
already used that field.
Click to expand...

What do you mean by "created"... when you designed the table? Or when
you tried to run your DLookup?

Yes you can do two "seperate" DLookups against the same table...
DLookup("[ID1]","tblEmpID", *your ID1 criteria here*)
DLookup("[ID2]","tblEmpID", *your ID2 criteria here*)
hth
Al Camp



Aurora said:
I am using Access 2000

Can I use the same Lookup Table to look the same
information twice - for 2 different fields. Ex:
Look up an employee ID number for a field called [ID1] and
then again for a field called [ID2]. Both fields using
the same Lookup Table called [EmpID]. I am having a
problem with this. When I created the two look up fields,
I got a message with the 2nd field to tell me that I had
already used that field.

Aurora
Click to expand...
 
I am using Access 2000

Can I use the same Lookup Table to look the same
information twice - for 2 different fields. Ex:
Look up an employee ID number for a field called [ID1] and
then again for a field called [ID2]. Both fields using
the same Lookup Table called [EmpID]. I am having a
problem with this. When I created the two look up fields,
I got a message with the 2nd field to tell me that I had
already used that field.

Aurora
Click to expand...

If you're trying to use the "Lookup Field" type in an Access table
definition... don't. See http://www.mvps.org/access/lookupfields.htm
for a critique.

It's perfectly plausible to put two Combo Boxes, with the same
rowsource, on a Form bound to your table. You can't do it *in the
table* - that's just one of the many, many limitations of the Lookup
Field misfeature.

John W. Vinson[MVP]
 
Back
Top