Forms based on queries or tables?

[m]

Hello,

I have a question that may seem silly but I am really
confused. I have created several forms based on queries
because I needed to extract information from several
tables. I had to set all of the Record set type properties
to Dynaset(inconsitent updates) in order to input
information into my forms. Obviously this caused alot of
problems. Should I have made my forms based on a
combination of subforms instead? In general is it better
to create forms based on a combination of subforms rather
than creating forms based on queries?

Thanks!

 

[Rick Brandt]

Hello,

I have a question that may seem silly but I am really
confused. I have created several forms based on queries
because I needed to extract information from several
tables. I had to set all of the Record set type properties
to Dynaset(inconsitent updates) in order to input
information into my forms. Obviously this caused alot of
problems. Should I have made my forms based on a
combination of subforms instead? In general is it better
to create forms based on a combination of subforms rather
than creating forms based on queries?

If you want to be able to edit data, then I would avoid multi-table queries
with your forms. Some very simple join queries will be fine with this but
you often get unexpected results. The use of separate forms or sub-forms
is more reliable.

 

[Jim Allensworth]

If you want to be able to edit data, then I would avoid multi-table queries
with your forms. Some very simple join queries will be fine with this but
you often get unexpected results. The use of separate forms or sub-forms
is more reliable.

But, with 3NF data it is difficult (and often undesirable) to present
and edit data from a single table. The important thing is how the
tables are joined. 1->1 is OK. 1->M can be if the query is structured
right.
Also, I have used forms with Dynaset (Inconsistent Updates) without
problems. I wonder if something else isn't the problem.

- Jim