Join Properties

[Rebecca_SUNY]

Does any one know of a shortcut for dragging and dropping to join two tables
where you can automatically set the join to include all the records of the
first table and only the records in the second table where the join fields
are equal? (or vice versa) I hate having to double click each join and
change this property.

 

[Jerry Whittle]

If you define the join in the Relationship window any new queries or
subform/subreports on those tables should have that type of join.