Hi everyone,

Is it possible to use a portal to display all records on the same layout that the records are.

e.g. Customer records, 1 per layout but the portal on this layout shows all customers.

Thanks in advance

Milton.

Join the table to itself by a cartesian join (the X join in the relationship graph) between the respective ID fields of the two table occurrences

Join the table to itself by a cartesian join (the X join in the relationship graph) between the respective ID fields of the two table occurrences

Thanks for that, works great.

Can I filter these records or am I stuck with all of them?

Milton.

Yes, you can filter them in several ways, but not by this relationship. How do you want to filter them?

Yes, you can filter them in several ways, but not by this relationship. How do you want to filter them?

Hi efen,

I have a field called status that holds a fixed value list: Paid up, Not Paid, Overdue.

This field is in the same table and the same layout as the customers.

Regards

Milton

Create a global text field gStatus in the table. Populate that with your value list, Paid, not paid etc.

Create a table occurrence of your table and join it by the gStatus field of the first occurrence of the table with the Status field in the new TO