On 9/12/24 16:01, Rich Shepard wrote:
I have one name in the people table who owns 5 different dairies with three different phone numbers, but all 5 have the the same email address. The five dairies each has its own name and location while the people table has five rows with the same last and first names and email address. Is there a way to have only one entry for the owner in the people table while related to five different company names? In some industries, such as dairy farms, this is not an unusual situation.
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.
TIA, Rich
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
