Hi! All,
I need to link 3 tables, let's say T1, T2 & T3.
T1 is the primary table, and it is one-to-more relationship between T1&T2 and T1&T3. If for each record of T1,I have 2 records in T2, 2 inT3, I will get totally 4 records in CR. This will cause performance problem becuase all 2 tables are huge in the product envrionment.
I know I can write a SQL query and use this query as the database. But besides that, can I do anything else to solve this problem within CR?
Thanks a lot
Knzy
I need to link 3 tables, let's say T1, T2 & T3.
T1 is the primary table, and it is one-to-more relationship between T1&T2 and T1&T3. If for each record of T1,I have 2 records in T2, 2 inT3, I will get totally 4 records in CR. This will cause performance problem becuase all 2 tables are huge in the product envrionment.
I know I can write a SQL query and use this query as the database. But besides that, can I do anything else to solve this problem within CR?
Thanks a lot
Knzy