Jump to content

Display all records in a portal


miltont
 Share

This topic is 4356 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4356 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.