Hi

I have problem that I trying to constrain an found set (table). The fielded I am using to do this was developed with an value list. The field as range of place like "Otago" "West Coast" "Auckland" and other place etc

what I trying to do is just show in the search "Otago" "West Coast" for example

I have tried some scrips... but don't seem to work, I can constrain an found set to just show "Otago"

any through on this would be great

Cheers

D

Hi Hack,

Not really clear on what you are trying to achieve here.

Hi there

I am trying search an field with more than one word

enter in an range of word. as if I enter more than one word, I do not get result

I have list that some show "otago" some show "Canterbury" "Wellington etc so when I search this field it show range of results not just showing "otago"

Hope this helps

Hack,

You need a Find Request for each item you want to find.

In Find Mode place "Otago" in the first find request, then go to Requests menu and "Add New Request".. in this new request type in "Auckland" (or whatever). Add a new request for each item you want. Learn the manual method first then this will help you with writing a scripted version..

I am still not understanding what you are looking for. Are yu trying to Omit records with "otago" or are you trying to find records with multiple entries such as.

Enter Find Mode []

Set Field [ YourField; "otago" ]

New Record / Request

Set Field [ YourField; "Canterbury" ]

Perform Find []

Which will return all records with "Canterbury" or "otago"

Hi All

thank you for help, the "Add New Request" did the trick

Cheers

D