2 Replies Latest reply on Mar 21, 2011 3:51 PM by SvenLoetscher

    Lookup a value in a second table using two relationship fields

    SvenLoetscher

      Title

      Lookup a value in a second table using two relationship fields

      Post

      I have two simple tables (client and currency).

      In the client table I have the fields client ID, amount, currency, date, rate and amount$.

      In the currency table I have the fields currency, date and rate

      I have tried to use the auto-enter's Looked-up value by specifying rate for the datafield to be returned.

      I've set the relationship to client:currency = currency:currency and client:date = currency:date, expecting that if I enter a valid currency code and date I'd get the rate to calculate the amount in $.

      However, no rate is looked up. Frown

      Thanks for any help!