client:currency = currency:currency AND
client:date = currency:date
That you post should work. Since it doesn't, you'll need to check the details involved. Are both date fields of type date? A both currency fields of type text?
Is this on a layout that specifically lists "client" in show records from in layout setup...?
Is the rate field in Client set up to look up values from Currency and not by some other name?
(The Table Occurrence boxes used to define the above relationships, must have the same name as the layout setup... and looked up value references in order for this to work.)
Thanks for the tipps.
The problem was, that I didn't reference back the fields Currency to the core table and have a second table occurrence for currency where I could relate the two dates.