Script Help

[stacysscott]

Ok I have DB that contains Fields Last Name, First Name, Dog Name, Random, Sat Run, Sun Run. Script 1 Sorts by Random # the user then assigns runs # based on random sort. I would like the data base to check and return a custom dialogue box if the same person (with a different dog) runs with in 3 people. I can not figure out the scripting.
Is there a place to just type script and not use the FMP tags?

 

[Schlogg]

Unfortunately, you can't type scripts.
What do you mean by "... runs with in 3 people."?
Are Run #s assigned in sequence (1, 2, 3 etc) once the file is sorted?

Cheers,
Paul J.

 

[stacysscott]

Yeah it is sorted randomly and then runs are assigned in order after the sort, I have a seperate field for the run # so the user can adjust if necessary.