if merged field is empty
I have a database that creates labels. Due to the fact that some of the names are long I have created relationships with the main table where the shortforms are listed. This means that I have two fields: one is the long form and the other short form.
Sometimes the user does not enter/forgets to enter the short form to the list, or its already short and there is no need to have unnecessary repetitive work by assigning a short name in the related table. However this will cause a problem. This means that the reports will come out with blanks if no short form is assigned. Is there a way to tell Filemaker that if one of the merged fields (shot form) on the report layout is empty then to use the long name?