Problem displaying form when using data from 3 tables

[azu_daioh]

I have the following tables:

[tbl_Claimant]
SSN (PK), FirstName, LastName, DOB

[tbl_ClmDetails]
recID (PK), SSN (FK), CED, FONum

[tbl_IDReferrals]
refID (PK), SSN (FK), and bunch more fields

I'm designing the form using all fields from [tbl_IDReferrals] with
[FirstName], [LastName], [CED], and [FONum] -- but whenever I try to
click to Form View -- my form is blank but on design view it show my
form.

The relationship is 1-many between [tbl_Claimant] and
[tbl_ClmDetails], and 1-many between [tbl_Claimant] and
[tbl_IDReferrals].

Can someone explain what I'm doing wrong please?

Thank you,
Sharon

 

[Jerry Whittle]

You probably have an inner join between the tables. If any of the tables are
missing a matching record, none of the record will be returned. In this case
you need a left or right join.

However if you juse a left or right join between multiple tables, the data
will most likely be unupdateable. This means that your form could not be used
to modify, create, or delete records.

Your best bet is to have a main form based on tbl_Claimant and subforms
based on the other two tables. Make sure to formalize the relationships in
the Relationships window with Referiential Integrity enabled first.

 

[azu_daioh]

Thank you Jerry. I will try your suggestion.