Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. andrad

    Multiple roles and addresses

    I created a better jpg, here it is http://members.shaw.ca/joso/diagram.jpg If you have any suggestions let me know. if anyone else has suggestions, feel free to let me know as well. thanks Joe
  2. andrad

    Multiple roles and addresses

    Thanks John for replying. So you from my diagram you think i'm ok with storing basic fields (lastname, firstname, etc..) in one table (person table) than split the roles into different tables like i have? You are right, i do have a website and fields unique to each role. I was originally...
  3. andrad

    Multiple roles and addresses

    Hi everyone! I am trying to figure out how a person can have multiple addresses with multiple roles. My database will consist of three types of people that will be entered, a client/customer, a doctor/health professional, a business contact. A client will have a home address, a doctor/health...

Part and Inventory Search

Back
Top