AnsweredAssumed Answered

Sort active and non active members

Question asked by RichardBrown on Aug 16, 2013
Latest reply on Aug 17, 2013 by GuyStevens


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