Searching Two Databases

[mattw]

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?

<INPUT TYPE="hidden" NAME="-DB" VALUE="DB1"><INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout #1">

and

<INPUT TYPE="hidden" NAME="-DB" VALUE="DB2"><INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout #2">

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

<INPUT TYPE=text NAME="field1" VALUE="">

and

<INPUT TYPE=hidden NAME="field2" VALUE="">

Sorry if this is hard to understand!!

Thanks

[dspires]

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.

[Robtech]

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

[flexistentialism]

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

[mattw]

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 ]

[mattw]

Hey,

Thanks to all, I have decided to use Portals/relational databases. Everything works great so far!!!