AnsweredAssumed Answered

creating a label which excludes inactive records

Question asked by cat22fish on Nov 4, 2014
Latest reply on Nov 4, 2014 by cat22fish


creating a label which excludes inactive records



I hope someone can help.  I have created a label layout from a contacts database which currently pulls in data from both active and inactive records.  I know that I can separate the active and inactive from a find before I create the labels, however I would like to include an If statement on the label layout as a back up which will omit all inactive records if someone else tries to create the labels and forgets to omit inactive records in the find. 

At the moment I have come up with this:

if (Inactive = "Inactive"; Go to Record [Next]; "")

The trouble is FileMaker calculation doesn't recognise go to record [next] even though this is in the help guide.

Or would it be a case of creating a script which automatically finds the correct records and create a button on the database which can be clicked for those who want to create the labels?

Any advice would be really appreciated - I am a complete novice so I'm probably making it much harder than it needs to be.

Thank you