Put some if Blocks in place that count the number of related records.
But instead of such scripting, I'd replace those fields with a set of one row portals to test_spec_test_fabric_info_colours. The first one row portal would be set with initial row: 1, The next with initial row: 2 and so forth. Such a set of one row portals, each set to display the next portal row is often called a "horizontal portal" in FileMaker lingo.
No scripts or calculations are then needed to display this data.
Thank you for the prompt reply.
There is a very specific reason why I didn't / couldn't use the portal for this...unfortunately.
I'm sorry to ask a silly questions, but would you be able to give me the example of full calculation using If for the Colourway Body 1?
I've never done any Filemaker training, so I am struggling with these scripting issues.
Please first explain why you can't use 6 1 row portals for this.