AnsweredAssumed Answered

Lookup misunderstanding

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

Title

Lookup misunderstanding

Post

     Hello,

     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? 

     Thanks,

     Serge

Outcomes