Cascading Portals

[Siri]

I am trying to use a set of three selection portals to pick the Items to display in an item purchase history.

The portals are Groups(of Items), Items, VendorItems (Items sold by a vendor).

The Main display portal should display VendorItem purchase history.

How it works now is you click on a GROUP name(in FIRST portal), the list of ITEMS in that group displays in the SECOND portal, you click on a item in the second portal and it displays the list of VENDORS that sell that item in the THIRD portal.

This will create the main portal to display that vendor item history.

The thing i'd like to change is, I'd like the first two portals (group and item) to display all records before you make a selection.

Also I'd like to be able to choose more than one record and have the next portal show a combined collection of records related to those parent records.

I'm not sure where to start whether I should use a repeating field or multiple fields.

I will post my file in the next post.

Siri

[Siri]

The Layout I'm working on is VendorItemDisplay

Cascadetrial.zip

[RDWirr]

This is a good solution for my bill of materials application too. But I have to question: how to make the tables related to the parent portal add new records in the secondary portals.

Thanks in advance,

RDW

[aaa]

Hi, Siri!

I little changed your file for your second question. If you check Choosing_many field you can in first portal choose many lines and see those items in second portal. I think that on this way you do your wish for next portal.

The first question can be solved too i will little think about this and attach you file.

Cascadetrial.zip

[RDWirr]

Thanks for the help with this AAA, I am looking for a little different solution though. I need to actaully add new records in the second and third portals instead of just displaying more of the records that are already in those tables. Is there a way to allow those related tables to create new records from within the 2nd and 3rd portals.

Thanks in advance,

RDW

[aaa]

Hi,RDWirr!

In the relation for this portals check Alow creation of records.