Set Portal to certain rec?

[pogrady]

Hello-

Is there a script or something that i can use to set a portal to retrieve all rows of a DB based on a critria? For example, the SQL would look ike this:

SELECT Speaker, Quantity, Cost FROM JobInfo WHERE OrderID="Current records OrderID"

I am not running an ODBC source on my computer, otherwise i would probably just write the SQL for it.

When i am in the "order" DB it works fine, but what i am hoping to acomplish is when i look up a contact,(in the conatcts DB) i can pull all the PO's that they have on file with us, click on a PO number, and it takes me to another screen where it shows the details of that specific PO, all without switching databases.

I can go to the related record in the Order DB, and it pulls all the info from there just fine, but when i try to do the same thing in the Contacts DB, it lists all the lines from each PO, even though it tells me that i am on one specific PO.

So i would like to force the Portal to only view records from that specific PO.

Does this maka da sense?