AnsweredAssumed Answered

Lookup misunderstanding

Question asked by justjoker on May 1, 2013
Latest reply on May 2, 2013 by philmodjunk


Lookup misunderstanding



     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?