linking two schemas 1

[kimchavis]

Hello all! I was hoping someone could help me with this problem Im having:

IM using 8.5,

I have 2 schemas that house identical tables, with the exception that one of the schemas houses a reference table and the other doesnt.

When I link either schema to the refernce table individually it pulls the data, however if i try to link both at the same time, It only pulls back data for the schema that it is housed in.


Any help with this is appreciated. THANK YOU.

 

[synapsevampire]

Add the reference table in a second time and link each of them separately.

-k