How display info from one table, but save to another table

[Guest]

I am creating a training database. I have the following tables:
participants - information on participant
courses - information about courses offered
classes - instance of course, session, room
students - ties participants to classes

In the participant form, I have a subform for assigning the participant to
classes (should create a record in students table for each class the
participant is assigned to), with the results being displayed as a classlist
for that participant.

I have created the dropdown list so that it displays the session/class in
the dropdown, and creates the student record, however it displays the classid
(from students table) after the selection is made, which is meaningless. I
would like it to display the information from the classes and courses table,
without creating any additional records in the classes or courses tables. I
would also like to be able to enter a session number in one control, and use
that to filter the dropdown list to just those classes offered in that
session (right now the dropdown displays all session/class combinations.

Any help would be appreciated!
Chris

 

[Michel Walsh]

Hi,


Have you tried to use a query? In a query with the table with *just* the
courseID, bring also the table that has the full record description for a
given courseID, and JOIN these two tables through their said CourseID they
share in common. In the grid, bring the fields you need. Once the query
works as you want, use the SQL statement, or saved the query, as rowsource
for a list control, or combo box.

You can add a criteria involving a value in a control in a form using the
syntax FORMS!formNameHere!ControlNameHere


Hoping it may help,
Vanderghast, Access MVP