AnsweredAssumed Answered

Tables Question

Question asked by Annette on Nov 30, 2012
Latest reply on Nov 30, 2012 by philmodjunk

Title

Tables Question

Post

      HI,

     I have a question that might be very stupid but I just want to make sure before I change things around.  I have a database that records various client information at the moment.  There is a clientinfo table which recoreds name, address, DOB, A staff table which records name, staff number, email and a Next of kin table which records name and relationship.  I now need to expand the database to record the address of staff members as well as the address of NOK.  Is the proper way to do that by creating an addresses table and linking it via relationships to the three seperate tables by their PK? 

      

     Thanks!

Outcomes