Hi, can't seem to get my script right. Have set 6 values in a Status field (E/PI/O/M/C/F). For each record or project one can only fill in one of the above mentioned values. Now I would like to filter all records with a value E, PI and/or O in a separate layout (list view).

Made a constrain found set: Project::status [E] AND [PI] AND [O].

But than non are selected or found because there is no record which contains all three values. I know I am doing something wrong here but somehow I am not getting it. The AND should be OR???

Thanks in advanced, Dutchy

Dutchy See here

Hello John, This doesn't seem to be working for me. I am not trying to search for one value in three different fields but searching for three different values in one field. In the field one can fill in 6 different values and I would like to filter out 3 of those in a table or list view.

It seems, I have to do something different then you proposed before? Can you help: I have tried everything I can think off and nothing is working properly. Thanks

Dutchy

You add a new Find Request and enter the second value in the SAME field, viz:

Enter Find Mode [ ]

Set Field [ yourField ; "O" ]

New Record Request

Set Field [ yourField ; "P" ]

...etc

I have know idea what I have been doing wrong all this time, but it is working now. Thanks a million, LaRetta and John.

Dutchy

Hi John,

New question concerning this post. I am trying to pre-fix a search or find button to search for records that have a status PI/O/E (status field) and are handled by a certain person, for example D (ID field). I would like this info to be pre-fixed because this search will be done often. However the name of the client can differ, so I need to keep the search open so that the client name can be filled in manually. The only script I can think of closes the find mode before I can fill in the client name. Can you help out? Hope I am clear? Here is what I have and is not working for me:

Enter Find Mode [project::ID;"D"]

Set field [project::status;"E"]

New Record/request

Set field [project::status;"P"]

New Record/request

Set field [project::status;"O"]

Preform find

Dutchy

Create a global field so that the user can enter a name or in this case ID (gNameID).

Enter Find Mode []

Set field [project::ID; gNameID]

Set field [project::status;"E"]

New Record/request

Set field [project::ID; gNameID]

Set field [project::status;"P"]

New Record/request

Set field [project::ID; gNameID]

Set field [project::status;"O"]

Preform find []

This will find all records in which if "D" was the value of ID, would yield all of D's records where teh status field is "E", "P", or "O"

Problem solved, thanks

Edited March 28, 200718 yr by Guest