k.. I've searched the forums and found a few posts on just this topic, but i must be missing some fundamentl understanding of scripting.

here's what i want to do. I have fields A, B, C, and D on a layout.

I want to put a FIND ALL field on the layout where the user can enter what they want, click a button, and all the fields(a to d) are searched with the entry.

Now, I set up a CalcALL field that puts these all together into one searchable field. what i'm missing is how to tell the script to take the data in the FIND ALL field and use it to search the CalcALL field.

I hope this makes sense, and sorry if this is basic.

thanks

Steve

First, The "FIND ALL" field MUST be a global fields or its contents won't be available for use when in Find mode.

Enter Find Mode[]

SetField[CalcAll, FIND ALL]

Perform Find[]

Without the CalcALL field:

Enter Find Mode[]

SetField[A, FIND ALL]

New Record/Request/Page

SetField[b, FIND ALL]

New Record/Request/Page

SetField[C, FIND ALL]

New Record/Request/Page

SetField[D, FIND ALL]

Perform Find[]

New request are "OR'ed", without the New Request steps, a record would have to match all four fields at the same time to be found.

-bd

Hi,

depending on how large is the db, and if fields A to B are

- indexed fields,

- of same format (but this is also true for the Perfor find script),

you could also use some kind of relationships here.

1.Create a stored calculation

Multi-key = "field A" & "