Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form with several tables in it. 4 tables are one-to-one, and one
table is one-to-many. I created the form with a form wizard. When I go to
enter data in the form it will allow me to enter data in the first table, but
not any any other one-to-one table. Allow addition is set to YES, it is
using a query for record source. Why will it not allow me to enter data.
 
I created a form with several tables in it. 4 tables are one-to-one, and one
table is one-to-many. I created the form with a form wizard. When I go to
enter data in the form it will allow me to enter data in the first table, but
not any any other one-to-one table. Allow addition is set to YES, it is
using a query for record source. Why will it not allow me to enter data.
Click to expand...

One to one relationships are VERY rare in correctly designed
databases. Normally you can just use a wider table with all the fields
needed. If you're not familiar with the terms "Subclassing" or "Table
driven field-level security" maybe you shouldn't use such
relationships... what are these tables?

If you don't (as I would suggest) restructure your tables, please post
the SQL of the query. Normally one would not use a massive five-table
query for this purpose; instead, you'ld base a Form on the "master"
table with Subforms based on the "child" tables. Even a one to one
relationship is directional.

John W. Vinson[MVP]
 
Back
Top