Need help with finds in portals.

[collings1]

Here's what I'm trying to do. Hope someone can help.<br>
<br>
2 databases - one contains hundreds of journal entries<br>
the other is where I view the data from the journal along with tons of other info.<br>
<br>
I have only one portal defined in the app.<br>
<br>
I know how to perform a find on the journal from the main database to find info, but I want to be able to display the found record in the portal without making the user scroll through dozens of records. <br>
<br>
Here's what I have now:<br>
search field - a string placeholder<br>
journal field - the database of journal entries<br>
a button to run a script to copy the search field info and place it into the journal field, and then perform a find.<br>
<br>
Works great up to this point.<br>
<br>
Now I want to jump to the record (viewing from the portal) where the info that was found appears.<br>
<br>
any ideas.<br>
<br>
Thanks in advance,<br>
<br>
Lee <br>
elc@collings1.com<br>
<br>
<br>
<br>

 

[doud]

One idea would be to define a calculation field in your main database that concatenates "1"(i.e.) and the field your link is based on if your journal field contains the string placed in your search field, else "0" <br>
<br>
You'd then have to define a calculation field in your second database that concatenates "1" and the field your link is based on<br>
<br>
Third step is to define a new link (in the second database) based on both new fields you just created.<br>
<br>
Then you duplicate your layout (still in the second database) and replace the original portal with another one based on the new link and replace the ancient fields by those from the new link.<br>
<br>
Your "search" button in the first layout would then just command a "goto layout XXX" (XXX being the layout you just created)<br>
<br>
CU<br>
<br>
Doud