Should forms be created based on tables or queries, or does it mat

[David K.]

Title prettly much says it all. Is it better to create forms based on table
or queries? Or, is there any real difference? If so, are there any benefits
with one or the other?

I'm fairly new at this and was just wondering what the logic or path of
thought I should be using to create my database.

Thanks in advance.

 

[Douglas J. Steele]

I always base my forms on queries. The benefit is that you can control the
order in which the records are presented by using an appropriate ORDER BY
clause in the query. In addition, if not all of the fields (or not all the
rows) are required for the specific form (or report), you can return smaller
recordsets.