Linking multiple tables in a query

[toolman74]

In the Northwind sample database they have an Invoice qry that includes
multiple tables all linked together. When I try to link more than 2 tables
though my form is blank. Also, using a subform won't work for this
application as I will have to intermingle the fields. If it helps, I have
the following tables that I need to link as I need info from each of these
tables included on this form:

tbl_Claim Info
tbl_Vehicle Info
tbl_Adjuster
tbl_Insurance Co
tbl_Total Loss Info

I need to be able to place a field from tbl_Claim Info right next to a field
from the tbl_Insurance Co and above a field from tbl_Adjuster

Thanks for any help!!

 

[Ryan]

Im just guessing, but if you dont have values in one of the tables, and you
join it in a query in another table, there will be no results. The way to
fix this problem is to change the join type. For example, if tbl_Claim has
data, but tbl_Insurance Co doesnt have any related records, your query will
be empty. In your query, right click on the relationship line and select
Join Properties. In the Join Properties screen you would "Include ALL
records from 'tbl_Claim' and only those records from 'tbl_Insurance Co' where
the joined fields are equal.

 

[toolman74]

Thanks, but I'm trying to make a form based on this info so I can then make
entries. The form shows up but I cannot enter info in any of the fields.
Thanks for any help!!

 

[John W. Vinson]

In the Northwind sample database they have an Invoice qry that includes
multiple tables all linked together. When I try to link more than 2 tables
though my form is blank. Also, using a subform won't work for this
application as I will have to intermingle the fields. If it helps, I have
the following tables that I need to link as I need info from each of these
tables included on this form:

tbl_Claim Info
tbl_Vehicle Info
tbl_Adjuster
tbl_Insurance Co
tbl_Total Loss Info

I need to be able to place a field from tbl_Claim Info right next to a field
from the tbl_Insurance Co and above a field from tbl_Adjuster

It's very rare indeed that a five-table query will be updateable; even if it
is, it will be as confusing as all get out, since the records in the "one"
side table will be repeated as many times as there are records in the "many"
side table.

Designing an Access Form - much less table relationships - on the basis of an
existing paper form will always give major headaches. If the "need" to
intermingle the fields is to accommodate transcription from a paper form,
you'll need to either train your users; revise the paper form; or (most
likely) go to a heck of a lot of work to design an unbound Form and write VBA
code to populate the tables.