I have 3 tables:

Designer, Styles, Messaging

The Designer table has a portal containing records from Styles matched by DesignerID.

StyleID goes from Styles to Messaging, and in each record in the Styles portal on the Designer layout, I want a portal displaying the matching records from Messaging.

However, currently, the second portal shows ALL the records from the Messaging table, as opposed to the ones associated by StyleID.

Any help would be greatly appreciated.

I am not sure I understand your question, esp. the relationship between Styles and Messaging. In any case, it's not possible to place a portal within a portal. Perhaps you could use a calculation in the Styles table, for example =

List ( Messaging::SomeField )

I am not sure I understand your question, esp. the relationship between Styles and Messaging. In any case, it's not possible to place a portal within a portal. Perhaps you could use a calculation in the Styles table, for example =

List ( Messaging::SomeField )

List works OK...

Is there a way to display just the last line of the list?

Is there a way to display just the last line of the list?

You could change the calculation to =

Last ( Messaging::SomeField )

You could change the calculation to =

Last ( Messaging::SomeField )

 

I am back with this and experiencing a problem.

 

I've reworked the database that had this before in order to improve on a few things and now my Last(Messaging::Text) shows up the same for every record in the portal.

 

The tables are as follows:

 

Variables holds a portal with records from the Styles table. They are related via the field Number1, which is global value, with value 1. This is so that all the 'Styles' can appear on this portal.

 

Styles is related to messaging as one-to-many via Style ID.

 

The field Last Messaging is in Styles with Last(Messaging::Text).

 

 

Am I missing something!?

now my Last(Messaging::Text) shows up the same for every record in the portal.

 

 

Why is the field in the portal to begin with? There is only one "last" messaging value for each style - IOW, it is an attribute of the parent style, not of any particular child in Messaging.

 

 

---

BTW, this is not really relevant to your question, but to show all records in a portal you should define a relationship using the X relational operator (and any pair of matchfields), instead of a constant.

Why is the field in the portal to begin with? There is only one "last" messaging value for each style - IOW, it is an attribute of the parent style, not of any particular child in Messaging.

 

The portal contains all of the styles.. So there is a field Last Messaging for every record in the portal. This should contain the value of the last message for each particular style?

 

 

BTW, this is not really relevant to your question, but to show all records in a portal you should define a relationship using the X relational operator (and any pair of matchfields), instead of a constant.

They are only related so that I can put the 'Styles' portal (from the table 'Styles') on a layout based on the table 'Variables'. I can't put a portal from Styles on a layout from Styles can I?

I've figured it out - I had to use the calculation for Last Messaging in the context of a different table occurrence!