Hi list.

I often encountered the need of multiple mastersources for TIB_Query. Here's a short example:

Tables:
TABLE1:
T1_ID INTEGER NOT NULL PRIMARY KEY,
T1_INFO VARCHAR(32);

TABLE2:
T2_ID INTEGER NOT NULL PRIMARY KEY,
T2_INFO VARCHAR(32);

TABLE3:
T1_ID INTEGER NOT NULL REFERENCES TABLE1(T1_ID),
T2_ID INTEGER NOT NULL REFERENCES TABLE2(T2_ID),
T3_INFO VARCHAR(32),
PRIMARY KEY (T1_ID,T2_ID);

I sometimes need two grids (one for Table1, the other for Table2) which coresponding TIB_Queries to act like masters for a third TIB_Query selecting rows from Table3.
TIB_Query3 MasterLinks would look like
TABLE3.T1_ID=TABLE1.T1_ID
TABLE3.T2_ID=TABLE2.T2_ID
MasterSources[] for TIB_Query3: [TIB_Datasource1,TIB_Datasource2].

I'm aware this might be difficult to implement, that's why I'm asking you guys. Would this be usefull for you also?

Thank you
Fane




[Non-text portions of this message have been removed]