one find/search on multiple fields?

[LukasB]

Goodmorning...

is it possible to have a search field? for 3 different fields?

I have a list of specific "categories"(value) that can describe what a company sells.

One company could be in more that one category.(it could sell 2 or 3 different products) so I have 3 fields that can describe a category of the company.

Can I make a single search for these 3 different fields (that will be filled by words of the same value list)?

I hope this is clear and makes sense...

thank you

ps. this value list has more than 100 entries so the order of entering the category in the 3 different fields could vary

[mr_vodka]

Enter Find Mode []

Set Field [ FieldA; "value" ]

New Record Request

Set Field [ FieldB; "value" ]

New Record Request

Set Field [ FieldC; "value" ]

Perform Find []

However, that being said, I think this would be a good time you to move to more of a relational model. If each company belong to more than 1 category, it screams relationship. You should create another table that joins the products table and the customers table.

[LukasB]

thank you mr Vodka, I'll try this right away.

I have created a relationship so that when you create a new record(company), there is a field which is the value(category) and another field which is a subcategory which is related to the selected value.

eg. "company" "category:electrical" "subcategory:external lighting"

is this what you meant?

[mr_vodka]

I think that your initial setup would need 3 tables.

Company

pkcompanyID

CompanyName

jcompCatg (Join table that connects Company and Category)

fkCompanyID

fkCategoryID

Category

pkCategoryID

CategoryName (external lighting)

GroupClass (Electrical, Plumbing, etc)

The join table is needed because multiple companies belong multiple groups.

[klj]

Mr. Vodka, I appreciate your time, I too have a similar problem. I need to search for the same item (person) who could be in three different fields. Currently I have a script that opens a new window containing a drop-down of one field, in find mode. The user selects the person, then clicks a button that continues the find. There has to be a better way, I just don't know how to get there.

Thanks in advance

[mr_vodka]

First, why is the name is 3 different fields?

Second, you could have a global field where the user enters the name and then a similar script can be run to perform the find for you or depending on the setup, you may be able to do it with a relationship as well.

[TDebb8594]

I'm trying to accomplish the same thing. The reason I have the same information in 3 fields is:

I have employees that are funded on several accounts. In the Employeefunding table, I create funding forms taht might contain split funding, ei. 1 appointment can be split (for instence) 25% on acct. A, 25% on acct. B, 50% on acct. C. Each allocation percent is entered in a separate area on the form.

Each allocation percent creates it's own line on a report.

The account number infnormation is pulled from a seperate table containing grant (funding) information. The employee information is pulled from the personnel table.

I need to be able to do a search for all appointments on Acct. A.

[pyap]

Just wondering if anyone figured this out.

The way we did it was we created temporary global search fields. We created a new find layout that was accessed in browse mode. The user fills in the search fields and either clicks continue or find. The script then goes into find mode, sets all the corresponding fields and then performs the find.

Hope this helps.