linking two tables in query

  • Thread starter Thread starter petermcg
  • Start date Start date
P

petermcg

I'm trying to link two tables using an ODBC table in query. Not all
records in the left table have an entry in the right table. I've tried
all combinations of the link properties but I either get only those
records that have entries in both tables or each record in the left
table duplicated by the number of records in the right table.

Any advice gratefully received
 
Hi there

You need to create the link in Query by dragging one field onto the other, then double-click on the link line. You'll either want option 2 or option 3 depending on which way round you want the relationship.

Hope this helps!

Julia
 
Back
Top