Membership setting whether show or date-range linked

Modified on 26/02/2015 10:59 AM by Suzanne Coy — Categorized as: Memberships and Tickets

Overview

The following article defines how to set whether Membership records should be show or date-range linked
This can only be done manually, by running the following appropriate SQL script:

To make Membership records link to Shows:

UPDATE tblsysConstants SET ConstantValue = 0 WHERE ConstantName = 'MembershipDateValidation'

To make Membership records generic across all Shows (i.e. based on date instead):

UPDATE tblsysConstants SET ConstantValue = 1 WHERE ConstantName = 'MembershipDateValidation'

Considerations

Consideration should be given to existing Membership records that will remain unaffected if this setting is changed. This setting should preferably only be changed when an organisation is first starting to use ShowBiz and hasn't entered Membership data.