You can approach this from the other direction. If you have a pointer field on the record, then the script can check this value, and then call the appropriate sub-script. Which seems to answer your second paragraph.
But on reading your first paragraph, I was thinking that you would want a join table between members and tasks? So that you would know what needs doing to who (so to speak) Forbes -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Rowland & Wilma Carson Sent: 23 September 2008 19:17 To: [email protected] Subject: select different script for each record? I am constructing a membership admin system which includes a number of "ticklers" for reminding the user when certain recurring jobs have to be done. That is all working fine, but I can't seem to figure out an elegant way to connect the right script to the task if the user says, OK, I want to respond to that reminder by doing the job right away. Each task is a separate record in a tasks table (with a seperate schedule table). I'd like to be able to store in some field of that record the script that should be executed when the task needs to be done so that there is no need to "hard-wire" any other stuff to activate the right script. I thought I must have done something like this before, but can't figure out how. Am I being really dense here, or is there no easy way to store a pointer to a script on a per-record basis? regards Rowland -- | Wilma & Rowland Carson http://home.clara.net/rowil/ | <[EMAIL PROTECTED]> ... that's Rowland with a 'w' ... -- ******************************************************************************** The information in this email and any files transmitted with it is confidential and may be legally privileged. It is intended solely for the addressee and others authorised to receive it. If you are not the intended recipient,, any disclosure, copying, distribution or action taken in reliance on its contents is prohibited and may be unlawful. Prospects Services Limited is a limited company registered in England and Wales. Reg No: 3042176 Registered Office: Prospects House, 19 Elmfield Road, Bromley, BR1 1LT. If you have received this email in error please notify: [EMAIL PROTECTED] http://www.prospects.co.uk This footnote also confirms that this email message has been swept for the presence of computer viruses ********************************************************************************
