Note: This post only applies to the Legacy database!We have one clubber who is listed against two clubs (Trek and T&T UA) and we can't change it.
1. As far as I can tell, there is only one clubber record. On the clubbers tab, she only appears once in the list when I show all statuses.
2. The only thing in her records for Trek are the date listings in the attendance tab. I tried deleting the attendance records, and that seemed to fix it. It removed her from the Trek check-in tab and the check-in / progress report, which was really the whole problem.
3. When I run the database optimization, it adds those records back in.
This is from the log and looks like it is relevant:
Verifying Club Session records for each active and inactive member...
... _________ was missing week number(s): 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,
Done.
4. In the Household members area she shows up 3 times- twice in Trek. This is probably the heart of the problem, but I can't make it go away. Any suggestions?