On Thu, 12 Sep 2024, Adrian Klaver wrote:
Quick and dirty: people_table person_id PK name_last name_first email_address ph_number ... location_table loc_id PK person_id_fk FK <--> people_table(person_id) loc_name loc_st_addr loc_st_city loc_st_st_prov ... contact_table contact_id PK loc_id_fk FK <--> location_table(loc_id) contact_ph_number contact_email --Can be null It can get more involved then this, depends on how flexible you want to get.
Adrian, There are many companies with multiple locations, but few owners with multiple companies, each with a different location. David's reminder about many-to-many tables will do the job. Thanks, Rich
