Look Up Tables

[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

 

[Al Camp]

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.

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

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

 

[John Vinson]

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

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]