You learn something everyday and I just learned that I can't search on an Association. Is is true that Associations are not a searchable function? And aside from Aliases are there any other workarounds I haven't thought of? We are looking at how we set up Foundation and Corporate Accounts and thinking of using Associations to track trustees and employee which would work ideally in our model if we could search by Associations.
Elizabeth Carlock
Director, Ticketing Services
The Granada
ecarlock@granadasb.org
In Milwaukee we have a procedure set up that creates alias records for certain types of associations, thus allowing them to be searchable. You could probably adopt the same model.
-p.
PATRICK SCHLEY | Marketing & Sales Manager | Milwaukee Repertory Theater Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202 414.290.0710 tel | 414.224.9097 fax | pschley@milwaukeerep.com Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep
Patrick,
We are looking at doing this at the Perot. Would you be willing to share out the script for your procedure?
Sadie
Hey Sadie - we deprecated the procedure back when we moved to v11 (as it was being used to create search aliases between parent & child, which households kind of eliminated the need for). However, let me see if our DBA still has the script somewhere. I'll let you know if I can find it. :)