I'm building a database for our Engineering Project Controls. I'm curious how people are linking their tables? Do you link them at the table level or the query level and why? What are the benefits to linking at the tbl level vs. the qry level.
Any insights would be appreciated. I'm getting some strange results (ambiguous outter join) and I wnat to make sure that my linking is done correctly.
Thanks for your insights.
Tammy