Forms based on tables or queries????

[frangipani]

Hi

I would like to know what is best practice for creating user input forms for my database.

I have read somewhere ( I am sure!!) that this is best done by creating queries and basing the forms on those queries, not the tables? Is this the case? The DB is for multi-users.

Any thoughts? or advice?

thanks

 

[Newman]

You could base them on tables, if that's what you want, without any problems.
The main advantage of using a query, is that if you add to your form and need expressions or fields from another table, you won't have to change the source of the form.
Also, if you always use the same name for the query and the form (ex.: QCustomers with FCustomers), it's easier to remember what is the source of a form. It will always be a query of the same name.
Newman