Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script Help

Status
Not open for further replies.

stacysscott

Programmer
Joined
Feb 24, 2005
Messages
4
Location
US
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?
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top