1 Reply Latest reply on Aug 17, 2013 2:37 AM by GuyStevens

    Sort active and non active members



      Sort active and non active members



           Would love it if someone can help me get my head around this ! I am building a database for my clients in a fitness studio. I have tables for Clients, Products (memberships), Line Items and Invoices. When making an invoice for instance I would like to be able to select from a list of Active Clients but also have the ability to choose from Non Active and/or All Members. I guess I need to set up some sort of value list in the header but should this be a Script, a Conditional Value List, a Global Filter, a 'normal filter' or what …? Would be great if someone can give me some pointers and/or point me in the right direction for looking at some examples. Best regards - Richard