I'm confused with Lookup...
I've got 2 tables - Trades and Mistakes - related by ID_Trade. A trade can be related to several mistakes. "Trades" has a Currency field.
I'm trying to add Lookup field to the Mistakes table to get the Currence definition stored at the Mistakes (I need it to sort the Mistakes by currency). Can't make Lookup. I just got a blank field on the Mistakes layout.
What am I doing wrong?