Creating a form

[sunrisewinesalon@yahoo.com]

New here--I posted this to another group called 'ms access problems,'
but it only had one member...

Access says you can choose fields from more than one table or query to
create a form--but can you use fields from one of each?

Thanks

[pietlinden@hotmail.com]

Re: Creating a form

make life easy on yourself. Create a query based on the tables and/or
queries you need in your form. Then base your form on that query you
just made. it sounds like you're creating a form/subform. Are you?
(Main form will be based on the first table, then the subform will be
based on the second table or query).