I have a Life Insurance Beneficiary form where employee can add upto 3 individuals (Name, Address, DOB, SSN and relationship).
Should I create 1 list with repeating columns (Name1, Address1a, Address1b, DOB1, SSN1, Relationship1 || Name2, Address2a, Address2b, DOB2, SSN2, Relationship2 || Name3, Address3a, Address3b, DOB3, SSN3, Relationship3)
I should follow relationship model where I would have a seperate table to list this values (Just one set of columns) and Make sure LIBKey matches between 2 lists.
What would you do? What is the best approach? (I will be designing a Infopath form and workflow so initial design should cost me too much dev time when designing these).
Just need your 2 cents. I know there are some good brains on this forum.