Portal within portal?

[macavity]

Is it possible?

In the main table there is a portal to create various sub-categories. The key field is the ID number of the main table.

I need to be able to create n-quantity of extra expenses that will be attached to subcategories. For this I made an expenses table and related it to the sub-category table through the same main table ID - and through a sub-category ID. (There is a straight connection from the main table through the sub-category table to the expenses table, based on the same ID.)

The ideal solution would be a portal within the sub-category portal on the main table. I've tried it, and it works to an extent: I can enter data and it will create a new record in the expenses table. However the expenses portal appears only in the first subcategory portal row and includes all expenses that match the main table ID, without regard to the subcategory ID (I created some records directly in the expenses table and gave them a different subcategory ID).

Am I missing something obvious or is this really not possible?

Thanks in advance for your help!

[Genx]

Is it possible?

No....

Either add an extra layout where you navigate from sub Category to Expenses... or alternatively, use a calculation field and utilize List() available in FM 8.5 to simulate a basic set of related info within a calculated text field.

[macavity]

Thanks. Anyway it saves me a lot of wasted effort and time.

[Brian C]

It is indeed not possible to create portals within portals but there are ways to work around the issue at least for display purposes.

From your description above it does sound like you need to create a multi-predicate key instead of a key that only shares a single ID across all 3 tables as the only link

Relationship #1:

Category::ID = SubCategory::ID_Cat

Relationship #2:

SubCategory::ID = Expenses::ID_SubCat

SubCategory::ID_Cat = Expenses::ID_Cat