weird question

[ice-9]

hi,
got a weird question.
Im working on a form atm (duh)
I have a form that exists in more tables.
Now you have 2 solutions: I can use a query and generate the form, or i can make various subforms.

what is the best option? or doesnt it make much diffrence?

 

[ice-9]

Forms don't exist in tables so I'm not sure what you're trying to say here.

Queries and subforms are not interchangable. All forms should be based on queries. If you want to show data from the 1-side table and the many-side table together, use a subform for the many-side data.

what i mean is that you have 2 ways to link one to many.
Using a query and using a subform. Both methods give the same result.