If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How display info from one table, but save to another table
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 |
#2
|
|||
|
|||
How display info from one table, but save to another table
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 "Chris" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using a subform to display and add info into table | ivalum21 | Using Forms | 19 | March 17th, 2010 09:36 AM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |