Lookup Field

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

Guest

I have a table with a lookup field that is pulling rows from another table. The table with the lookup field and table that provides the lookup field values are connected by the index of a third table. Anyone know how to limit the number of rows that show up in the lookup field based on the particular index (to the third table) in that current record

In other words, is there any way to get the value of a field in the CURRENT record, the record where the user is using the lookup combo box?
 
MJ,

I do not believe that this is possible in the design of a table. Also I
would not recommend using a lookup combo box in the design of a table as it
does negatively impact your peformance.

The best way to do this is to design a bound form that is based on your
initial table. A combo box can then be designed to lookup values based on
your third table.

Regards,
Dan

MJ said:
I have a table with a lookup field that is pulling rows from another
Click to expand...
table. The table with the lookup field and table that provides the lookup
field values are connected by the index of a third table. Anyone know how to
limit the number of rows that show up in the lookup field based on the
particular index (to the third table) in that current record?
In other words, is there any way to get the value of a field in the
Click to expand...
CURRENT record, the record where the user is using the lookup combo box?
 
Back
Top