Table or query

Mikey F

New member
Local time
Today, 12:27
Joined
Feb 16, 2002
Messages
5
What's the difference between basing a form on a table or query?

Simple question I know...

Mike
 
With a query you can sort columns, show data from more than one table, do calculations and other data manipulations that you cannot do with a table. This doesn't mean that you shouldn't base a form on a table though. You will have to decide which is best for you and your application.
 
When I started out, I didn't understand how to use fields from several tables on one form and it drove me nuts! Queries have eased my troubles. I make a query that contains whichever fields I want from any table and base my form on it. Plus all the bonuses Jack mentioned. Ahhhh, isn't it sweet!

If your form only needs fields from one specific table and you know that will probably remain true, then base your form on the table. No use creating a query if it's not necessary.
 

Users who are viewing this thread

Back
Top Bottom