cmakedonas
Posts: 1
|
Posted: 06/08/2004, 2:07 AM |
|
Hi,
i am using a table Module Class, having two keys, a composite key.. The Module Code, and the Class number (This is for a school database)
Where for each class many students are assinged and i have tha class enrolement table.
So, 2 tables one to many relationships, where the composite key is a foreigh key to the class enrolement table.
I want to have a page to enroll the student to a specific module and then to a specific class.. and i thought i could do this with combo boxes.
Is this feasible? and how?
|
|
|
ghtracey
Posts: 23
|
Posted: 06/08/2004, 9:45 AM |
|
A combo box can be filled from any table in the DB, so that isn't an issue. Create your class enrollment record using combo boxes for both of the key fields. On their properties pages set the datasource connection, table, bounc column etc... They don't have to be from the same table as the record, as long as the bound column contains the value that you want to be entered into the record.
Hope that helps.
_________________
Graham Tracey
Council of Yukon First Nations |
|
|
|