Simple

[Mike-LI-NY]

Hey

I have two db's A & B.

the results of a find are displayed in FILE B

and I have a portal in FILE A wirh the fields from FILE B in the portal, but no data is showing up, even though it exists in FILE B. WHat am I forgetting? I know it has to be something simple...

Thanks!

M

[dbruggmann]

Your portal in File A displays all the records from File B which match the relationship upon which you based the portal. That means you can have in File three portals, each based upon a different relationship and each showing three different sets of the records from file B.

For the display in the portal it doesn't matter at all if you do a find in file B or not, it only depends on the relationship. That means if you want to change the displayed records in the portals you have to change the relationship. Usually you do this in file A by changing the left field of the relationship (as seen in the relationship define dialog); this can be a field particular to the record or a global field. To do this you can use for example a pop-up list with different values, or a checkbox or radio button field, or buttons with scripts. For your case you have to figure out, which values in file A have to be changed, that only the records you want to see, in file B match.