Form going blank - relationship problems

[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

 

[Linq Adams via AccessMonster.com]

Usually, Forms that show no controls in Form View have

No data in the underlying table/query

and

The Form's AllowAdditions Property set to No, otr the form is non-updatable
due to the query's construction

Check the AllowAdditions Property first, and if set to No set it to Yes and
see if that helps.

 

[Beetle]

Queries involving more than two tables are usually not updateable, which
is why your form won't display any blank rows for adding new info.
Typically, you would create a separate query for each table, then set up
forms/subfoms based on the queries.

Having said that, on the surface your table structure doesn't seem to make
sense. It's hard to say since I know almost nothing about your db. I only
bring it up because it's important that your tables be properly set up before
you move on to creating queries/forms. If you post an example of your
tables/fields and how they are related, someone can advise you as to
your table structure.