Display all records in a portal

[miltont]

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.

[efen]

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

[miltont]

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.

[efen]

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

[miltont]

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

[efen]

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