So I have been trying to develop a solution to program a school..... I have a file with the following fields...class, period 1, period 2, period 3 and so on. In the fields I have obvious data... class- "801", period 1- "gym" period 2- "math" so I have no problem when I find by class where they should go for each period, but I want to turn the schedule around and list it by subject as well, so if I find "Math", I would want to see period 1- *702", Period 2-"801, Period 3-"802... I assume I need to do a relationship file, but I can't for the life of me figure this out. Can anyone help?