A Real Sticky Problem

[Guest]

I created a query that joins two tables into one form. One table is the
active one and the other is archived information. So, for instance a clients
most recent data for 2007 is in table one, but the older data is stored in
table two.

The problem is that the form is not displaying the newest clients entered
into table one. It is 8 off. Is this because there is no similar entry in
table two?

Can this be resolved by assigning a primary key to table one?

 

[Douglas J. Steele]

If you're just doing a simple join (an Inner Join), you'll only get details
for those clients that exist in both tables.

You can do a Left Join that will give you all records in Table1 and the
corresponding records in Table2: in the query designer, highlight the line
that joins the two tables, right-click and select Join Properties and choose
the appropriate option.