How to put data from different data source into a form?

  • Thread starter Thread starter AccessLearner
  • Start date Start date
A

AccessLearner

I want to create a form and the data are from two tables.
These two tables have no any relationship.
Is this possible? How should I do?

For example:
The form has two part, one part is about student's
information and the other part is about course information.
When you enter the StudentID, the form will get student
name, gender, Major etc. from students table and fill these
information automaticlly. The course part has information
like course name, course Number, etc. from course table .
Besides that, there are some choices you can choose or
enter some text inform.

Thank you.
 
Make a form for student details, and another for course details. Make a
third form with two subform controls. Put the student details form into one
of those subform controls, & the course details form into the other subform
control. Voila: two forms in one, as it were.

Of course, with that simple scheme, there is no relationship between the
subforms. The student details subform could display any student, while the
course details subform displayed any course. However, by adding suitable
code & a "junction" table behind the scenes, you could have a button which
would add the currently displayed student to the currently displayed course,
& so on. This would be perfectly do-able, but significantly more complictaed
than the simple, un-coordinated form.
..
HTH,
TC
 
Back
Top