Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to link the tables if smart linking is not working
- Thread starter skiabox
- Start date
It depends entirely on what information you are trying to get out.
if you want all the information in both the tables and the view t hen you should use an equal join on them all. if however you need some information from one table and some from another then it might take longer to run.
it would help if you gave examples of what your tables hold and what information you are trying to get out of your report.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
if you want all the information in both the tables and the view t hen you should use an equal join on them all. if however you need some information from one table and some from another then it might take longer to run.
it would help if you gave examples of what your tables hold and what information you are trying to get out of your report.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- Thread starter
- #3
I can't think of any instances when I have used smart linking, because it ordinarily does not link correctly. How you link is critical to your report results, and you should read up on this and learn to understand it fully. If you do this incorrectly, your report results will be inaccurate.
In general, an equal join requires that there be matching records in both tables, so that if one or the other table contains non-matching records, they will not appear on the report. A left outer join can be used if you want to show all records from the left-hand table and only matching records from the right-hand table, but you cannot use selection criteria on the right-hand table or it will "undo" the left outer join. Those are the only two joins I've ever had to use, but it is important to understand them.
It also matters whether you have placed fields from each table on the report--if not, and if you have not "enforced" the join, the join will have no impact on the table that has no fields displayed.
-LB
In general, an equal join requires that there be matching records in both tables, so that if one or the other table contains non-matching records, they will not appear on the report. A left outer join can be used if you want to show all records from the left-hand table and only matching records from the right-hand table, but you cannot use selection criteria on the right-hand table or it will "undo" the left outer join. Those are the only two joins I've ever had to use, but it is important to understand them.
It also matters whether you have placed fields from each table on the report--if not, and if you have not "enforced" the join, the join will have no impact on the table that has no fields displayed.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question