what's the best way to use multiple tables in a form?

I wish not to use subforms....is there another way to combine multiple table fields into one form? Your reply would be greatful. thank you.

One possiblity is to create a query which includes the different tables you wish to have on the form. Then create a from from the query. This only becomes really confusing if you have similarly named fields in the tables you choose for the query.

Good luck

Peter Paul