data entry form based on more than 3 tables?

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

Guest

normally we are taught that the database has to be normalized so as to make
it fast and errorfree.i have got a database where i split the table into 8
tables [manually].when i started preparing a form based on these
tables,dependent tables are accepted as only subforms,that too only 2
subforms.
other way round was to use command buttons,irritating while entering the data
table analyzer wizard assured that original form would work even after
splitting,but produced weird tables.
 
It's difficult to advise you based on the information
you've posted. Post a generic description of the purpose
of your database, the fields you wish to include, and any
one-to-many relationships that exist (e.g., "Customers"
and "Orders", and "Orders" and "Order Line Items" are one-
to-many relationships). Knowing better what you're trying
to do will enable people to better help you.

Also, understand that the weirdness you perceive may just
be the difference between how you generically think about
your data entry screen compared to how it's best to store
your information. Frequently, the underlying table
structures may be totally invisible to the user--he
doesn't care whether an Order date and the address of the
customer who placed it are stored in different tables, as
long as he can see it all on screen at the same time. But
you'll have to construct both a reliable, easily
maintained data structure and intuitive, user-friendly
forms.

Will be glad to help when I understand better what you're
trying to do.

HTH
Kevin Sprinkel
 
Back
Top