Page History: Membership setting whether show or date-range linked
Compare Page Revisions
Page Revision: 23/11/2011 12:39 PM
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.