I don't know if this is even possible, but here we go ... I have a single-user database ... it is a very simple alumni mailing database with names, addresses, phones, e-mails, etc., and year of graduation. At various times of the year, I have various classes preparing for their reunions, and the class reps who are organizing everything would like to be kept abreast of address changes for their class as they come in. As organized and with it as I'd like to pretend to be, on some days when the address changes come in fast and furious, I forget to pay attention to the year the individuals graduated and to whether or not I should be forwarding the change on to the class rep. What I'd like to do is program FMP to alarm anytime I access a certain graduation year record. So, for example, right now the Class of 1993 and the Class of 1964 are in their planning stages, so anytime I access a 1993 record or a 1964 record the computer would ding at me (but stay silent for any other graduation year). Or next year, it would ding at me for 1984 or 1955, for example.

Is this even possible? By the way, I am working with a Mac, not a PC, if that makes any difference!

Thanks in advance for any feedback!

Peg Moser

[email protected]

There is a script step down at the bottom of the list called 'Beep'. You haven't told us how you access this particular records however. I assume you have a 'Year Graduated' field, but we need to know more.

Steve

all you need is a calculation with a container as result

beep=if (your condition here,g_beep,"")

g_beep being a container global holding a sound

now access your records per script and include a go to field[beep, select/perform] script step