Problem with Find Script - Posted for Techy

April 26, 200322 yr

From: techy

I was trying to post for help on this problem.

I am trying to find/omit records over multiple fields.

I have a Postcode Field (Main DB)(set as a valuelist checkbox) this works fine on it's own.

I have a Members Field (Relational DB) again works fine on it's own.

I have a County Field (Main DB) again works fine on it's own.

I need to find AND/OR Omit Records that match ALL 3 Fields?:

My Current Script is.....

show all records

enter find mode[pause]

set field["membership:membership"]

omit record(depending on what the user enters)

new record/request

set field ["county"]

omit record (depending on what the user enters)

new record/request

goto field["postcode"]

set field["postcode","not isEmpty(postcode & "

May 2, 200322 yr

Newbies

test post

2 weeks later...

May 15, 200322 yr

Hmmm... how about have a calculated field that is a concatenation of the three fields you search on.

Then set up 4 global fields. The first three getting populated by the you're above script SetFields. Then 4th global being a calculation field defined like the previous one to do the concatentation. Then omit all records where the global field matches the non global concat field.