AnsweredAssumed Answered

child tables inside parent table

Question asked by emmawatson on Aug 27, 2013
Latest reply on Aug 27, 2013 by philmodjunk


child tables inside parent table


     I need to add function of viewing the history of each record in my db (date, comment, mb smth else that will be managed manually and automatically (e.g. date)).

     Now I see only one way to do this: to create separate table for each record. However I'm not sure if it is a good idea and moreover I do not know if it is possible to script this (creating table for each record).

     Also I though about creating many additional fields directly to the records in my db and then write history records there, however it is not a good idea either: history records will be limited to number of additional fields and it will be necessary to create tons of additional fields.

     Any suggestions how can I realise this?