Searching in different tables

[BenCho]

Hello.

The database I am currently working on consists of several tables, and some of them are not connected.

(E.g. there is a table LOCATIONS and a table STAFF.)

My aim is to have one single layout where a user can enter his search terms.

(E.g. there would be a search field for location, for First Name, for Last name.)

On top, there would be a search field where you can search all the desired fields at once.

As long as I have tables that are related to each other I can place the according fields on the layout and everything works fine; I created fields that search in several fields at the same time and so on. But as mentioned: Here I have got some tables are not related to each other.

Also, is there a possibilty to show all the results from all the tables on one layout?

Thank you!

[Ocean West]

Ah your searching for the "Google" or "Spotlight" style search results?

There are methods where you can script a search in all tables on all fields the get a result set back (parent id) then present this on a "dashboard" or "search results" layout.

here are some pointers...

http://www.filemakermagazine.com/videos/single-field-quick-search.html

http://www.filemakermagazine.com/videos/field-script-triggers.html

http://www.filemakermagazine.com/videos/faster-or-search-script.html

http://www.filemakermagazine.com/videos/user-friendly-searching.html

[BenCho]

Hey Stephen,

Yes, a Google type search on different (not related) tables is more or less what I am looking for.

I have watched the mentioned videos, must admit though, that some of them (the interesting ones!) I had to leave in the middle of the show, as they are a little too advanced for my level. So, looks like I'll have to do some homework first! :

Thank you for your input!

Ben :P

[Lee Smith]

Hi Ben, and Welcome to the Forum.

I have been a member of ISO FileMaker Magazine for a long time. IMO, it is a bargain at 24.95 (USD) a quarter, for what I get in return.

Lee

[BenCho]

Um, yes, I've subscribed today, but the videos didn't solve my problem... But I'm sure to get to know some interesting bits & pieces (have already)

:

[Ocean West]

here is an example file I had...

spotlight_search.fp7.zip

[BenCho]

Hey Stephen,

Thank you for the file and your advice. I'll play with it for a little while and will get back.

: Ben