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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.