Creating a Form from 2 queries

[Guest]

I have two working queries that I would like to use to create one form. I
get an error message that I have chosen fields from record sources which the
wizard can't connect. You may have chosen fields from a table and from a
query based on that table. If so, try choosing fields from only the table or
only the query. If I chose just one of the queries I don't get that message.
Am I not allowed to combine queries in a form? I also tried in report and
got the same results. I added a relationship between the two queries and
stil ge the same message.

 

[Guest]

What about using a subform and use the common field as the Master/Child link
between the form and subform.

 

[Guest]

This works but doesn't make for very pretty presentation. I have done this
to get us through this project but am wondering if there happens to be any
other alternative solutions that would allow for a more uniform looking
presentation of the data from the two tables.

 

[Guest]

What about using a report and subreport?