Find Function on multiple fields

[js22]

Hello,

I'm constructing a database for a chemistry lab that I work in. It is an inventory database and I'm writing a script that will perform a search function.

In the database there are three fields i would like to search: "Common Name", "Formal Name", and "Alternate Names". Chemists are not too bright so we have 8 names for everything. All three fields are in the table "Supplies".

What I would like is the ability to search all three fields at one. This is my current script that performs a search of the field "Common Name":

Enter Find Mode[]

Show Custom Dialog["Find An Inventory Item"; "Enter Item Name"; Supplies: Common Name]

Go to Field [supplies::Common Name]

Perform Find[]

Sort Records[Restore; No dialog]

Halt Script

This works fine for searching the common name field. If anyone knows how to expand the find so that I can search all three fields and show the records I would be most grateful.

Thanks

js22

[Ender]

How about:

Enter Find Mode[]

Show Custom Dialog["Find An Inventory Item"; "Enter Item Name"; Supplies: Common Name]

If [ not isempty(Supplies:: Common Name) ]

Set Variable [ $Name ; Supplies:: Common Name ]

New Record/Request

Set Field [ Supplies::Formal Name ; $Name ]

New Record/Request

Set Field [ Supplies::Alternate Names ; $Name ]

End If

Perform Find[]

...

[js22]

Thanks so much, that was just the trick.

js22