In Table_1, fieldA is a key to a similar field in Table_Of_Info. Any
lookups in Table_of_Info for Table_1 work fine.
In Table_2, fieldB is set up as Table_1::fieldA. (It must always be the
same value as fieldA in Table_1. The two tables are keyed through a
common Index key). If I make a relationship having fieldB of Table_2
also being a key to the similar variable in Table_Of_Info,
no lookups in Table_2 work.
Is there some way to get around this ?