AnsweredAssumed Answered

Indirect Lookup?

Question asked by CountryBoy1 on Jan 10, 2009
Latest reply on Jan 12, 2009 by CountryBoy1


Indirect Lookup?


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 ?