Problem with Relationships for Building Form

[toolman74]

Please help, I am new to this and so frusterated. I created tables for our
small business for Insurance Co, Insurance Adjuster, and Assignment Info (we
do claims service for multiple insurance companies). I have established
one-to-many relationships from both Insurance Co.tbl to Assignment Info.tbl
and Client Co.tbl to Insurance Adjuster.tbl as each insurance co has multiple
adjusters and sends multiple assignments. I also enforced referencial
integrity on both relationships. This isn't working when I create a form
though. I get no errors but my form goes completely blank (no fields even
show) when I leave DesignView. I've tried basing the form on a query, I've
tried a form with subforms and nothing changes. Please note that when I have
only 2 of the tables in the query - for instance Insurance Co.tbl & Insurance
Adjuster.tbl the form works -- it's when I have all 3 together that it
doesn't. Thanks so much!!!

Pamela

 

[John W. Vinson]

Please help, I am new to this and so frusterated. I created tables for our
small business for Insurance Co, Insurance Adjuster, and Assignment Info (we
do claims service for multiple insurance companies). I have established
one-to-many relationships from both Insurance Co.tbl to Assignment Info.tbl
and Client Co.tbl to Insurance Adjuster.tbl as each insurance co has multiple
adjusters and sends multiple assignments. I also enforced referencial
integrity on both relationships. This isn't working when I create a form
though. I get no errors but my form goes completely blank (no fields even
show) when I leave DesignView. I've tried basing the form on a query, I've
tried a form with subforms and nothing changes. Please note that when I have
only 2 of the tables in the query - for instance Insurance Co.tbl & Insurance
Adjuster.tbl the form works -- it's when I have all 3 together that it
doesn't. Thanks so much!!!

Pamela

You're going about it the wrong way. It is not necessary to create One Grand
Master Query that does everything, because (as you have seen!) it can very
well do NOTHING instead!

Rather than creating a Query containing all the tables, use a Form for the
"one" side table, with one or more Subforms for the "many". This will let you
enter (say) multiple adjusters for each company, and multiple assignments for
each adjuster, or whatever fits your business model.

The form is showing up blank because your Query will not return any records
until the tables have data in them; and you can't enter data into it because
your multitable query is not updateable. So... don't use the query for that
purpose!