March 4th, 2003, 05:53 PM
I have a database that manages individuals and the organizations they work for. I want to add membership management to it. There is a Link table between the tblIndividuals and the tblOrganizations to handle the many-to-many relationship. For example;
The key fields are:
My problem is there can be individual members and organization members. Any suggestions would be very appreciated. Thank you.
March 5th, 2003, 12:27 AM
My problem is there can be individual members and organization members. Any suggestions would be very appreciated.
If I understood you there'd be a foreign key to the organization table. But a member many not necessarily be attached to an organization.
If this is the case, you'd need a dummy organization record with say with a primary key value 0
OrgKey = 0
Name = 'None'
Description = 'Not part of an organization'
MemberKey = 99
MemberName = 'Sally Slacker'
OrgKey = 0 <--- key to tblOrganization that indicates she's not enrolled