the walker Posted April 9, 2002 Share Posted April 9, 2002 can you have a portal within a portal by this i mean i have company database within which i want to show their orders (which is fine) done in a portal i can show all of their orders. BUT each order has a list of order items stored in a file related to the order file. in the order file i have a a portal showing a list of all the items in the order (great) i basically want to show the list of order items in the company file is it possible and has any of this made sense the relational scheme goes company----<orders -----<items [ April 09, 2002, 07:48 AM: Message edited by: thewalker ] Link to comment Share on other sites More sharing options...
andygaunt Posted April 9, 2002 Share Posted April 9, 2002 Hi, If you have a global field called _gorderlines (same type as your order id field. Create a relationship from this to the line items database relating to the order id. Then script your order portal to Set field [_gOrderLines], to the order portal relationship::orderid] Basically, you look at a company and see all their orders. Then, when you click on an order it sets the global field to the order id. This is used in a relatioship that will show all lines for that order. HTH Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8053 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 accountSign in
Already have an account? Sign in here.
Sign In Now