Hi,

I have 2 tables: a "transact" table to record every payment for a "Customer" table. I created a portal under customer layout so as to view all the transactions for a particular customer.

Question: How can I create a sequential number next to every portal record to show how many transactions there are. Currently I can only view the records but I have to count the number of records. Many thanks in advance.

Use Count(YourPortalRelationName::Any_Field) for show "how many transactions there are";

Use @@ before every record in portal for "create a sequential number"

Cheers. I will digest your solution and let you know if I have further queries again. Thanks.

Sorry I am rather new FM7. Are you able to show me the steps on what you meant by a) Use Count(YourPortalRelationName::Any_Field) and b)Use @@ before every record in portal. Thanks for your help.

Rgds

If you want to display a total outside the portal, then create a calculation field with Count(PortalRelationship::serial), where PortalRelationship is the same relationship that the portal uses and serial is the unique identifier for each related record.

If you want each row to display a sequential number, starting from 1, then type @@ on your layout and then put it within the portal's first row.

See attached for examples.

sample.zip

thanks for the tip.. this helped me get up to speed on something new.