I have a table with all my actors I call Patrons. I have a comments field for anything that would apply to an individual but I want to keep track of status and activities that can be applied consistently to a group and I may want to filter against. For Example:
- Deceased
- Moved
- Source: Phil
- Source, Dave
- Attended 2015 Fundraiser,
- Attended 2014 Fund Raiser
- Board member 2014
- Hostile
As you can see, I could pick two or more categories for any one contact.
I plan to create a table with all my categories and then a table linked to my Patrons & Categories table with the Patron ID and the category.
This seems the logical approach. Would you suggest a different one?
Thanks
__._,_.___
Posted by: jan.hertzsch@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar