Create multiple records at once in linked table?
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!