Skip to main content
March 6, 2023
Question

Need to add multiple phone numbers.. on screen and want to store in DB .. what could be the best approach

  • March 6, 2023
  • 6 replies
  • 0 views

Need to add multiple phone numbers.. on screen  and want to store in DB .. what could be the best approach

6 replies

harshitb6843
March 6, 2023

Use a one-to-many relationship with your main table. The main table will hold the ID of the person/entity and then another table will hold the primary key of your main table where you will have multiple rows, one for each phone number, having the same personID. 

Hope that helps!

March 6, 2023

yea frm DB side i am also thinking to do the same .. to maintain normalization