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'''<br>
<br>
The following article defines how to set whether Membership records should be show or date-range linked<br>
This can only be done manually, by running the following appropriate SQL script:<br>
<br>
'''To make Membership records link to Shows:'''<br>
@@UPDATE tblsysConstants SET ConstantValue = 0 WHERE ConstantName = 'MembershipDateValidation'@@<br>
<br>
'''To make Membership records generic across all Shows (i.e. based on date instead):'''<br>
@@UPDATE tblsysConstants SET ConstantValue = 1 WHERE ConstantName = 'MembershipDateValidation'@@<br>
<br>
'''Considerations'''<br>
<br>
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.

Meta Keywords: date, linked, membership, show
Meta Description:
Change Comment:

Showbiz Help

Navigation¶

Membership setting whether show or date-range linked