N
Nick
I need to re-use member numbers for my club. The database
that I have set-up, has an auto number primary key for
each member and each member is issued the next available
lowest member number. As members becomes A = Achieved or X
= Declined, their numbers become available for re-use.
They retain their member number so that if they are re-
instated and their original member number is available for
re-use. So if a member is F = financial, N = New, NF = Non-
Financial, I need to prevent any new members or re-
instated A or X members from being issued a duplicate
member number.
Can anyone give me some direction on how to overcome this
problem?
All help appreciated
Nick
that I have set-up, has an auto number primary key for
each member and each member is issued the next available
lowest member number. As members becomes A = Achieved or X
= Declined, their numbers become available for re-use.
They retain their member number so that if they are re-
instated and their original member number is available for
re-use. So if a member is F = financial, N = New, NF = Non-
Financial, I need to prevent any new members or re-
instated A or X members from being issued a duplicate
member number.
Can anyone give me some direction on how to overcome this
problem?
All help appreciated
Nick