Display Multiple Queries or Tables

[Guest]

How can I display multiple queries or mutiple tables in one form? (As I
understand, I can only include one query or table in control source of the
form. So is it possible i could include multiple queries or tables in control
source? or is it other way to do?)
Please give me any suggestion. Thanks in advance.

 

[Tom Lake]

How can I display multiple queries or mutiple tables in one form? (As I
understand, I can only include one query or table in control source of the
form. So is it possible i could include multiple queries or tables in
control
source? or is it other way to do?)
Please give me any suggestion. Thanks in advance.

If there's a relationship between the tables you can use subforms to display
the related data.
For example: One table has a student name, address, date of birth and a
unique student ID.
A related table has the student ID, and test scores. Note that there may be
multiple records
in the scores table for a single record in the student table since a
particular student may have
one or more test scores.

Tom Lake

 

[Douglas J. Steele]

If there's a relationship between the tables you can use subforms to
display the related data.

Even if there isn't a relationship between the tables, and you strictly want
to show multiple tables on the same form, you can still use subforms. Just
don't define the Master and Child field links.