Jump to content

Set Portal to certain rec?


This topic is 7215 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • 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?

Link to comment
Share on other sites

This topic is 7215 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.