I am setting up a bilingual database to register children for events. The database will only be used once per event. After the event, the database will be emptied out to use for the next event. During each event, the children will be placed into 4 groups that rotate to individual stations (ex. event, snack, video, exercise). Students will get name tags (printed from the database) that will be color coded based on their group.
Here is a simplified version of the relevant tables:
StudentTBL
---------------
StudentID
FirstName-Lang1
LastName-Lang1
FirstName-Lang2
LastName-Lang2
Grouping [one through four]
AlergyID [related to AlergyTBL]
ColorTBL
--------
ColorNumber
ColorName-Lang1
ColorName-Lang2
ColorHexValue
AlergyTBL
---------
AlergyID
AlergyName-Lang1
AlergyName-Lang2
AlergyImage
I plan to have a toggle button on my forms that will allow the user to toggle between a Lang1 or Lang2 interface on the forms -- but that is for anther day.
My issue is with printing name tags.
Problem 1:
I want to match[StudentTBL].[Grouping] to [ColorTBL].[ColorNumber] and then use the corresponding [ColorHexValue] as the value for the background color property on my nametag form. I've tried to several different ways that I've seen on forums, but I'm not having any success.
In other words, children in group 1 should have nametags with a green background; children in group 2 should have nametags with a blue background, etc.
Problem 2:
I want the nametags to display the child's allergies, if any. At this point, I don't care if it is a textual display or if it uses the PNG/JPEG icons in [AlergyTBL].[AlergyImage]. Since the number of alergies is not static, I assume I could not have the database form do this without some type of additional scripting but I thought I would ask.