Among other things, the database keeps track of members' names and donations. Each member (could be an individual or a couple) is assigned an Envelope Number under which their donations are made. In the great majority of cases where there is both a husband and wife, donations are made under the same EnvNbr.
UniqueID 1, Fred & Sally Carruthers, EnvNbr 12
In a few cases, for Income Tax purposes, husband and wife prefer to make separate donations, each having their own separate EnvNbr, thus to get individual receipts.
UniqueID 2, Jack & Susan Ford, EnvNbr 13 SecondNbr 14
I have worked out a way to add this second number, with a check box to indicate it is a second number. And in the query behind the Receipt report, I can assign the second number to Susan Ford through the following logic
IIf([SecondNbr]=True,[FirstName2] & " " & [LastName],[FirstName] & " & " & [FirstName2] & " " & [LastName])
So the donations for EnvNbr 13 would be assigned to Jack & Susan Ford.
The donations for EnvNbr 14 would be assigned to Susan Ford.
What I would like to do, in these cases would be to have...
Donations for EnvNbr 13 assigned to Jack Ford (not Jack & Susan)
Is there a way to do this? Keeping in mind that in the great majority of cases there is no SecondNbr? Or is there a better way to construct the process from the outset?
One way, of course, would be to separate Jack and Susan Ford into separate records. But this is not very practical because it makes things such as a members' directory look odd.