AnsweredAssumed Answered

Create multiple records at once in linked table?

Question asked by FredH on Nov 4, 2014
Latest reply on Nov 15, 2014 by FredH


Create multiple records at once in linked table?


Hi experts,

I have table A that is linked to table B that is linked to table C.  A to B is 1to1 and B to C is 1toMany.  When creating a new record in table A, I would like to also automatically create the corresponding record in B and 6 records in table C.

For the moment, I have a simple button in my layout that creates a new record for table A which also creates the corresponding record in table B.  If I want now also to create the 5 records in table C, I suppose that my "simple button" will have to become a script?  
Any idea what is the best way to set this up?

Based on a date/year that is specified in table B (using data entry), I would also like to have 5 years populated in a column of table C (Y1 = year of table B, Y2 = B+1, etc.).  What would also be your approach for that?

Thanks in advance for your input!
Kind regards,