alternative to lookup wizard

[sammers101]

So I've read that using the lookup wizard is a bad idea in the table view so I am wondering what I should do instead

Basically I have a a table "CardList", I'd like to be able to add a new purchase to my Purchases table where I would select the card from those in "CardList" from a drop down box.

 

[mahenkj2]

Please read another thread "How to update foreign keys in a table." in which I have the same kind of query and got very much helpful info. I hope after going through that you would be able to understand look up fields issue and solve your issue.

best regards.

 

[sammers101]

alright so I think I figured it out,
set a field as UNIQUE
I need to set up my relationship
then I can add a fields from two different tables to my query

Currently there is no drop down box though, for rarity. I am only allowed to enter values from the rarity table, but I'd like to be able to select them rather than type them in.
I'd like one to be there for entering data into either card list (table) or card list Query