Searching Two Databases

May 9, 200124 yr

I hope someone can help me here,

I would like to search two or more, separate databases from the same search page.

Is this possible?

Can I join these?

and

and I think my Search field needs to be looking for two different calculation fields within the databases. These are calculation fields, which are used to help search multiple fields

and

Sorry if this is hard to understand!!

Thanks

May 9, 200124 yr

You can't directly search multiple databases on a single search (form) submittal. You can, however, have multiple form submittals (searches) on a single web page (multiple search buttons each performing different searches on different databases). In addition, you could set up multiple databases with relationships/portals to indirectly search them on a single form submittal.

May 10, 200124 yr

You can search multiple databases using portals and relationships.

1. Pick the main db to be your search database

2. Make sure that he other databases you want to search are in a portal on the main db form inside FileMaker

3. Make sure that there is a proper relationship between the main db and the other db's you want to search.

4. On your online search form set the name of the search fields with "relationship name::field name"

As long as the relationships and portals are properly done and that your search reply page reflects the proper field name properties (relationship name::field name for the data in the other db's) then this should work.

Good luck

Rob

May 11, 200124 yr

Or use inlines! you can search as many databases as u want from one page with inlines

May 14, 200124 yr

Author

quote:

Originally posted by flexistentialism:

Or use inlines! you can search as many databases as u want from one page with inlines

I am fairly new this stuff, can you (or someone) give me an example of an inline action for my situation. I have read some about them but I wouldn't pretend to know how to put the one together.

[ May 14, 2001: Message edited by: wrukie ]