School Database: HELP with Dynamic Menus ------ !!!

[Ollie Dog!]

I am attempting to build upon a classic school database which is designed to track [color:blue]STUDENTS, [color:blue]CLASSES and [color:blue]INSTRUCTORS.

In this database, Classes are identified only by their unique id field and not by a discernable name convention such as "Biology 101" or "Algebra-2" for example. Thus, to enroll a student in the proper section, the user (registrar), must be able to match the following fields to each class id:

[color:brown]- ClassDay

- ClassTime

- ClassInstructor

From a UI perspective, I need to show the user a [color:blue]drop down menu lsiting ALL the possible classes, diplaying {[color:brown]ClassDay, ClassTime, ClassInstructor} for each menu item.

e.g.

[color:blue]

--------------------------------------

Mon, 3:45 PM, Jackson

Wed, 1:30 PM, Sanders

Wed, 8:30 AM, Peterson

Fri, 2:00 PM, Wilson

---------------------------------------

On the STUDENTS Detail page, the registrar should be able to simply select one of the menu items listed to add that student to the class roster.

_________________________________________

_________________________________________

[color:red]Q: What do I need to do on the students detail page

to make this menu selection work dynamically with

the data contained in the [color:blue]CLASSES table?

- [color:red]NOTE: The Value List option I tried will only show a max of two attributes (I need to show all three).

- Is there a better method to achieve this design goal?

: Please HELP

Edited September 23, 2005 by Guest

[Genx]

Why dont you just make a calculation field that has something like the following in it:

Left ( ClassDay;3 ) & ", " & Hour ( ClassTime ) & ":" & Minute ( ClassTime ) & ", " & ClassInstructor

... Then make this ... with your no discernable naming convention class id as the first value ... and this calculation field as the second value ... your value list...

That way the UI and the relationships are preserved... the class can be recognised and selected easily, and the only value thats stored is the id...

[Ollie Dog!]

YES! - that's the solution I needed.

Thanks for your input. ???