Finding via a portal

[chlowden]

Hello FM people,

I have another luddite problem that I am sure is in the manual somewhere but I can't seem to find the solution (Fm is devilishly complicated).

I have 2 databases that have similar info. I wish to search both the databases with via a 3rd DB using portals. I wish that the result of the search be opened in new windows via the original DBs. In short the 3rd DB is just a "collective serach window" on the 2 originals.

I have managed to create portal links from both original DBs in the third using the "relationships" window. I know that the relationships work.

To complicate things, I have 2 "checkbox" value lists, one from each of the old DBs. I have created portals for them in the new DB and they show up in the new DB fine.

The idea is that by filling in the text box and the checkboxes, FM will throw up any that corresponds in the orginal DBs.

I presume that I need a script of some sort to get the results out but I cannot find the right one.

Is there anyone who can push me in the right direction?

Thanks