Apr 1st, 2012, 8:11 PM
Hi,
I have a form set up with a parent/children relationship in it.
As an example the form has name information -
First Name
Last Name
Address
Etc.
..and within the page there is place to add contact information -
Contact Method [EMAIL, PHONE]
Contact Type [MOBILE, HOME, WORK] etc.
Contact [EMAIL ADDRESS or PHONE NUMBER]
Contact Note [ADD OPTIONAL INFORMATION]
I have (through javascript) allowed the contact section to be duplicated as many times as necessary.
Assuming it is duplicated 30 times, I obviously would not want to leave so much extra space in the database, so I prefer to store it in a separate table.
Any ideas what would be the best way to implement that the name information would go in one table, and the rest would go into another table - with the name id in one of the fields to link them together (or any other method that would accomplish the same thing)?
Any ideas?
Thank you very much.
I have a form set up with a parent/children relationship in it.
As an example the form has name information -
First Name
Last Name
Address
Etc.
..and within the page there is place to add contact information -
Contact Method [EMAIL, PHONE]
Contact Type [MOBILE, HOME, WORK] etc.
Contact [EMAIL ADDRESS or PHONE NUMBER]
Contact Note [ADD OPTIONAL INFORMATION]
I have (through javascript) allowed the contact section to be duplicated as many times as necessary.
Assuming it is duplicated 30 times, I obviously would not want to leave so much extra space in the database, so I prefer to store it in a separate table.
Any ideas what would be the best way to implement that the name information would go in one table, and the rest would go into another table - with the name id in one of the fields to link them together (or any other method that would accomplish the same thing)?
Any ideas?
Thank you very much.