Display Multiple Queries or Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Karen said:
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.
Click to expand...

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
 
Tom Lake said:
If there's a relationship between the tables you can use subforms to
display the related data.
Click to expand...

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.
 
Back
Top