Form going blank - relationship problems

  • Thread starter Thread starter toolman74
  • Start date Start date
T

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
 
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.
 
Back
Top