January 16, 200223 yr Newbies 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?
Create an account or sign in to comment