Does anyone print current membership level on any of their ticket designs, and if so, would you be willing to share the LP_TICKET_ELEMENTS code you used to create that user-defined element? Thanks in advance for any help!
We don't print membership levels on our tickets but could something like this work for you? It will only give you active memberships and ignore merged or inactive but if you have customers with more than one active membership it will just take the top result.
If @ude_no = 1 and @customer_no > 0 Select top 1 @ude_value = IsNull(memb_level, '') From tx_cust_membership Where customer_no = @customer_no and current_status = 2
Thanks, Thomas! We do have a couple of organizations in our consortium with more than one membership organization but I think I can rig this to work even for them.