lookUp

[Balen]

HI I have Two Field ItemID and Item in table 1.
I want to use those fields in other table,
for Example if i have other table that contains Item & itemID if I select one Item how get item id to ItemID field?


thank you

[RuralGuy]

The other table should *only* have the ItemID field and you then create a query that joins the two tables on the ItemID field. Your query will be able to display the Item field as if it is all in the same table by simply changing the ItemID.

[Balen]

thank you very much