|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 11th, 2008, 09:05 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Join Properties
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. 
|
|
#2
July 11th, 2008, 09:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Join Properties
If you define the join in the Relationship window any new queries or
subform/subreports on those tables should have that type of join. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Rebecca_SUNY" wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
