servebot

Thanks, I'll try out all your suggestions. Too bad FM7 doesn't just us do it in a more straightforward way! --- Michael

I'm looking for some way to change the contents of a field similar to the Set Field script step, except I want to use a calculation to determine the target field instead of choosing from a list. Is there a way to do this in FM7? Thanks for your help, Michael

The script works! The "New Record/Request" step was exactly what I needed to make this work. Thanks everyone. ----------- Michael

Ralph's method works, but I need something more flexible, since users will be entering their own combinations of values. Rod's method works perfectly, but I need to automate this with a script. Is there a way to perform or simulate "add new request" in a script? --------------- Thanks, Michael

I'm having trouble scripting a combination AND OR search using FileMaker7. For example: A search for all records where Parameter_1 is A or B or C, AND where Parameter_2 is 1 or 2 or 3. Done correctly, this should find those records matching all nine permuations of the search criteria (A1, A2, A3, B1, B2, B3, C1, C2, C3). Hope this makes sense. Any advice? Thanks for your help, Michael

I have FieldOne with values A, B. I have two other fields called BlockA and BlockB. I am trying to write something that refers to either BlockA or BlockB depending on the value present in FieldOne. Something along the lines of: do something to the field called "Block" & "value-of-FieldOne". For example, if the value of FieldOne is B, then I want to do something to the field called "Block" & "B", which is "BlockB". Can anyone help me to write a calculation in FileMaker7 that refers to a field in this way? Thanks for the help, Michael