Storing dynamically generated fields
Storing dynamically generated fields
Out of context: Reply #8
- Started
- Last post
- 8 Responses
- ********0
One way of achieving this would involve creating 2 extra tables.
One table to store the extra values, and another to link your main table with the newly created extra values that have been created.
The link table contains the ID of the record in your main table and the ID of the record in the 'extra values' table.
Each time the user adds an extra field, you add a record to the 'extra values' table, and update the link table to associate it with the current main record.
When it comes to reading your data, you can create a query which collates the data in your main table together with those relevant, matching records from your 'extra values' table.