Im on a parent table I want to count the child records through a portal. I want that If there is only 1 Item..It will show 1 Item..if it is 2 or more it will show 2 Items... 3 items..etc..
Create a summary field on the child table (table portal is based on)-You want to count the foreign keys, call is sCount.
Create a calculation field for display:
sCount<1; "No Items";
sCount<2; "1 Item";
sCount & " Items"
You could put a merge field on the layout.
Thank you so much!
Retrieving data ...