Portal showing found set

[buckbuck]

I would like to create a portal on an ORDERS layout (table ORDERS 2008) that shows a 'found set'.

For ease of use I want to design a layout with the Order on the left and a Tab Control to the right. The Tab Control will hold a series of Portals. Two of these portals currently are: 1) a list of all the Orders in descend chronological order, 2) the payment history of the Contact . These are imbedded and working.

Another useful portal, the 'Found Set' portal, would show all the Orders where field, Status_Order = "Ordered". This limits the list to those Orders not shipped. Shipped orders are; Status_Order = "Shipped".

Some of you might say create a List View layout of the Orders and a button to navigate to this layout. However, this is not as elegant as the Tab Control approach since with the Tab Control you do not have to navigate away from current Order to see the information you want.

I hope this is clear. Is this possible? How?

Thanks

Matt

PS: My layout relationships are predictably:

ORDERS_kp_OrdersID = CONTACTS_kf_OrdersID (this gives me the Contacts Order History)

CONTACTS_kp_ContactsID = ORDERS_kf_ContactsID,

ORDERS_OrdersPortal_InvoiceList_All X ORDERS_kp_OrdersID (this gives me the portal that shows all Orders

[fmbug]

Your question is not clear, please expand it more if possible...

Your question is not clear, please expand it more if possible...

or attach a demo file to it....

[comment]

See if this helps:

http://fmforums.com/forum/topic/66980-portal-using-the-layout-source/page__p__317650#entry317650

[buckbuck]

Your question is not clear, please expand it more if possible...

I rewrote my query at fmforums regarding portal found set.

Thanks

Matthew

[Ron Cates]

Since you already have a portal showing orders you could ad a filter by a dropdown list to restrict the portal by selecting either "Ordered" or "Shipped". With a little extra work you could include a selection for all. Or if you use a checkbox set you can easily just select both to see all the orders.