combine record information from radio button field

[ggh]

I've got a field formatted as a radio button which indicates which day of the week a student is registered for a class. Each class is registered separately in its own record. I'm trying to find to show all of the days a student has registered for a class. This database has a class table, student table and a separate table to hold registration records. Any help would be appreciated!

[Ender]

Can you clarify a few things:

Which table is this "day of the week" field?

Are you trying to (1. find registrations for a particular day, (2. find students that have a certain number of days accounted for, or (3. find students and show all their registrations in a list.

[ggh]

The day of the week field originates in the class database, but it also appears on each registration record through a relationship-based calculation . What I want to be able to do is quickly see which days a kids is registered in a class. I've got several reports, based on the student table, which show contact information, medical info etc.. We want to add a field which shows registered class days. Clearer?

[Ender]

An easy way would be to show all classes for a Student in a Portal of Registrations. Unfortunately, this may not be that easy for the user to visually scan though the portal to see which days have registrations.

Another method would be to add a relationship to Registration for each Student-Day of Week combination. In this way, you could have a calc show which days have Registrations, or simply show a portal of Registrations for each day. These relationships would require a Day of Week field in Registration. This field would have to be stored and indexed so it could be used as a match field in these relationships. It would have an auto-enter calc or lookup defined to pull the Day of Week from the Class table.

Then in the Student table, define a global field to hold the parent key for each Day of Week (gDayMonday, gDayTuesday, etc.) Populate them with the correct Day of Week text or number (whichever you're using.)

You would need to add an additional table occurence of Registration for each day of week. The relationships would then look like this:

Student <-> Registrations Monday =

Student::StudentID = Registrations Monday::StudentID

AND Student::gDayMonday = Registrations Monday::Day of Week

Student <-> Registrations Tuesday =

Student::StudentID = Registrations Tuesday::StudentID

AND Student::gDayTuesday = Registrations Tuesday::Day of Week

etc.

Another method would be to use your exiting relationship between Student and Registration in a value list definition. The value list would show the related Day of Weeks from Registration. Then the value list could be used in a calc:

RegisteredDays (calculation, text result) = valuelistitems(get(filename); "Registration Days")

Either method will probably require a little tweeking to get the result text to look how you want. For example, the value list method produces an alphabetical return-separated list of Day of Weeks.

[ggh]

Thanks! You've given me a couple of ideas to try! I love this group!