Relating repeated fields conditionally

[dugfish]

This is difficult to describe, but here's a simplified version of my question:

I'm developing a teacher and student database for a school. In the teacherjobs file, there are fields for each teaching position (1st_homeroom, 2nd_homeroom, 6th_math, 7th_math

[-Queue-]

Value lists based on a related repeating field do not work in 7 as of yet. I think you would be much better off creating a record for each teacher and a Grade field in each. Then you can easily create a value list based on all teachers relating to a particular number in the Grade field.

[RalphL]

First I recommend that you do not use repeating fields. I don't know your experence level but I suggest that unless you are an experienced relational database developer you forget that you ever heard of repeating fields.

It looks like you have a many to many relationship. This will require a third file to join the student to the teachers.

For your value list you should look at a related value list.

Jimmy Jones of FileMaker Inc has a school database in FMP 7 that you might find helpful. It can be downloaded from:

http://www.kevinfrank.com/my_school.zip