Searching multiple fields through a single field

[avida]

I am building a solution that has 4 databases. The names of the files are Invoicing, Products, customers, and line Item. I have relationship between them. For example I have a relationship from invoicing to customers that supplies all the information about the user before creating an invoice. In the invoice database I have 5 fields that the user can use to search for a particular invoice. Three of those fields come from the customer

[spb]

Make your sixth field a global field. When the user enters something, they would have to click a "go" button next to the field that activates a script. From here you could do one of two things. Your script could create five find requests, like:

Enter Find Mode (do *not* check restore)

Set Field (Field1, SixthField)

New Request

Set Field (Field2, SixthField)

New Request

Set Field (Field3, SixthField)

New Request

Set Field (Field4, SixthField)

New Request

Set Field (Field5, SixthField)

Perform Find (do *not* check restore)

Set Field (SixthField, "")

Go to Layout (Display)

It is important that the Enter Find and Perform Find script steps have the "restore" option unchecked. Also, note that I clear the global enter field for the next entry.

Alternatively, you could make a concatenation calculation field (Field1 & " " & Field2 & " " & Field3 & " " & Field4 & " " & Field5), stick it out of sight on a working layout and simplify your script to:

Enter Find Mode (do *not* check restore)

Set Field (ConcatField, SixthField)

Perform Find (do *not* check restore)

Set Field (SixthField, "")

Go to Layout (Display)

Steve Brown

[avida]

Thank you very much Steve.