One field searches all?

[defectivo]

Hi Everybody,

So here's my little problem, I have a database to organize a school guidance office. There are four guiance counsellors and 20 slots in which students can book appoitnments (4 counselors x 20 slot fields = 80 fields where appointments can go into. I know this is a bit of a weird system but it has worked amazingly to date (although the next version will have portals probably).

Here's my situation, the counsellors would like a way to search EVERY appointment slot in the system. However, is there a way that I can set one field where the user enters the search string into and then have the text copied from this one to all the 80 other ones?

I've tried some copy and paste steps in my scripts but I couldn't get those to work. I would truly appreciate a step-by-step breakdown of the script. Each appointment slot is labled like Counsellor1Appppontment1, Counsellor1Appointment2,...

Thanks for all your help everyone!

[aaa]

Hi, lonjim2!

Create one layout with all your fields then script near:

Go To Field Counsellor1Appppontment1

Loop

SetField[,text]

Go To Next Field

ExitLoop if Status(CurrentFieldName)="Counsellor1Appppontment1"

EndLoop

Edited November 3, 2005 by Guest