AnsweredAssumed Answered

I need help writing a calculation that returns a list of unused numbers in a field that contains unique values between 1 and 100.

Question asked by chase43078 on Sep 27, 2017
Latest reply on Sep 28, 2017 by fmpdude

I am a choir director, and I have a table with misc choir member info. Each singer is assigned a folder number between 1 and 100. As I add members, I want to see a list of available folder numbers that are currently not in use. I am new to Filemaker, but I am certain that an intermediate user could solve this problem very quickly. Thanks in advance.

Outcomes