Contacts table data design
Posted on 2010-01-09
I have been working on a Contact Management programme for a few months now to use at my work. I have been asking my employees how they currently do things so that I can make sure that the software i develop compliments what they are already doing and hopefully makes it easier.
My contact table (tblContacts) has:
It has been mentioned to me that some companies have more than one contact associated with them. What would be the best way to do this? Would it be a separate contacts table (tblContacts) or is there a better way?
I envisage the main contacts form having some sort of button below the two fileds contact_fname and contact_lname with 'Add another Contact@ or something so that the user could select this and add more.
Just a thought.
I appreciate your suggestions.