query auto populates master table

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

Is there a way to get a query based on multiple tables, in
this case 2 tables, to fill/populate a "master table"
whenever a form is used?

When a student uses the form, FormClassRegistration, to
register for a class I would like a master table,
TableMasterClass, to be populated with the entered
information. I have a query, QueryMasterClassList, which
gathers data from 2 tables (class info and student info),
but can I get this query to run after the student enrolls
for a class and have it populate the master table,
TableMasterClass?
 
Sounds like you have it backwards.
You define the Master tables first.
Then provide your forms with drop downs that allow students to pick them.
You do not allow the students to define them.
 
Back
Top