Using forms with tables or queries

[Guest]

I am in the design phase of tracking system in Access. A relational database
has been modeled (includes eight tables) enforcing referential integrity
where ever applicable. In this system there will be a form for data entry.
The data entered into this form will actually be inputing data into four
tables since I have three different instances where a one-to-many
relationship could be found. I have designed a form that consists of one
main form and three subforms (attached to main form) to capture this data.
Is this the best way to do this? I have been told that creating the form
from a query may be a better solution (of course the person who told me,
didn't know why). Is this true? If so, why? And by using subforms, will
there be any performance issues and could I encounter any problems in the
future?

Thanks.

 

[Guest]

Hi

Yes use a query to base your form on
You can sort the records (using more than one field if req)
You can add calculations
You can use the query to resrict the number of records
etc
etc
etc

If you set up your subforms correcty there will be no problems with
performance

 

[John Vinson]

I am in the design phase of tracking system in Access. A relational database
has been modeled (includes eight tables) enforcing referential integrity
where ever applicable. In this system there will be a form for data entry.
The data entered into this form will actually be inputing data into four
tables since I have three different instances where a one-to-many
relationship could be found. I have designed a form that consists of one
main form and three subforms (attached to main form) to capture this data.
Is this the best way to do this? I have been told that creating the form
from a query may be a better solution (of course the person who told me,
didn't know why). Is this true? If so, why? And by using subforms, will
there be any performance issues and could I encounter any problems in the
future?

Thanks.

As a rule, I'd suggest using subforms. You may have some sluggishness
opening the main form *if* the tables involved are large (large
meaning hundreds of thousands of records); there are techniques to
ease this burden.


John W. Vinson[MVP]