Form/subform

[nancy]

I have created form that selects names from the volunteer talbe and a Family
member that has a relationship to the the volunteer table.
I have the two talbes in one form, but the FamilyMember table is not a
subform.

The form will only pull up name with familymember names assigned to it.
How do I get the form to pull up a volunteer name that dose not have family
member names assigned to it?

 

[Chegu Tom]

It sounds like your form is based on a query that joins the volunteer table
with the family member table

The problem is with the kind of join. Inner Joins will only show records
that have matching fields in BOTH tables. They will not show the volunteer
if there is no matching familymember. Right and Left joins allow more
flexibility showing you all of the rows in one table and matching rows from
the other

Go back to the query editor and open that query. Right click on the joining
line and chose join properties. Look at the three options. Chose the one
that will show all rows in the Volunteer table and rows that match in the
familymembers table