Merge field shows only field from the 1st related record
I am a novice FM Pro10 user. I need to create a letter which will display the service a customer has subscribed for and associated serial numbers that go with the equipment needed for the service.
I created a calcuated field SerialNumber:
If ( IsEmpty ( Service 1 ) ; "" ;"Equipment Serial Number: "&Inventory::MAC )
which I insert as Merge Field on a layout. This works, sort of, since only first serial number gets dispalyed and there are in some cases more than one which I need to show.
Can you help?