query auto populates master table

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?
 
J

Joe Fallon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to finding student Rank and How to upload bulk marks of each student at a time. 1
auto filling a master table 1
scheduling database 3
Sort form records by field looked up in another table 1
Master/Detail Form using a Query 9
populating a table automatically from a query 1
Subform child/master link question 2
Text box query 1

Top