Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Topic: Linking tables Posted: 02 Nov 2009 at 11:38am
I am using 3-tables in a Crystal Report (XI). What is the best way to link these tables? Below is an example of the scenario:
Table1: WOREF, LOCATION, STATUS
Table2: WOREF, ORGCODE, PRIORITY
Table3: WOREF, CONTRACT, VENDOR
When I link these tables, is it better to link table 2 and 3 to table 1, or link table 3 to table 2, and then link table 2 to table 1? Or would it make any difference?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 02 Nov 2009 at 12:07pm
Likely you will do table 1 to 2 and 1 to 3 here.
There is no hard and fast rule as it all depends on how how the DB was designed. The information in one table relates to the information in the other tables which can be different in a table by table basis when constructing the DB.
Mor likely in this instance you will need to be more concerned about using an inner join versus an outer join.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
