form does not show all the records from two forms

[Fiaz]

I created two table one to one relationship and fill the record in one table
and some record in second table and view.
Form only show the record which consist on both the table but i desire to
display data of both the table either the one table have more record and
other less

 

[Tom van Stiphout]

On Wed, 18 Feb 2009 01:35:03 -0800, Fiaz

Whenever you query, use an Outer Join. Right-click on the line between
the two tables.

-Tom.
Microsoft Access MVP

 

[Golfinray]

Try using a subform.