field validation help

[izmatic]

hello!

this is my first post EVER! so please be kind. ive searched everywhere on the site to try to find an answer but nothing...

so here is my setup:

i am building a school scheduler where the user can see assigned "rooms", "periods", and "class". these 3 fields are on a table called "scheduler". And each of the fields are foreign and grabbed from their respected tables.

what i need is validation calculation for each field (rooms, periods, class) that examines that no record creates duplicates.

the tricky part is this:

- a "rooms" can have the multiple "class" but not the same "period".

- and vice versa, a "class" can have multiple "rooms" but not the same "period."

example:

Room 100 = Class 4A = Period A

Room 100 = Class 5A = Period B

Room 200 = Class 5A = Period A

Room 200 = Class 4A = Period B

thanks in advanced for the help, and i really hope i made sense. }:|

[John Mark Osborne]

There is an example on my web site that you can modify to meet your needs:

http://www.filemakerpros.com/Duplicatesv7.zip

There are actually, 5 techniques in this one file so look at the Validate method.

[izmatic]

thanks a lot!

the file is very informative. i will try to incorporate the calculation into my file.

[izmatic]

i got everything to work. thanks again. :thumbup:

[John Mark Osborne]

Thanks for letting us know!