Create multiple child datas when creating parent data

Hi everyone, newbie here for appsheet. But i am good at SQL. After searching for solution in community, i created my first topic. Salute you all.

I have a grouped parent product and child products has also child datas.

For example. I have suit which include jacket,shirt,trousers and tie. Each suit parts also can be selled individually. Each parts has its own size,color and importance. Level determines suit color and size. Lets says we have red jacket,gray shirt, blue trousers and white tie. Since we set jacketโ€™s importance to primary. Suit color will be red. We ignore other parts specs. And the imagine with the size combinations. It will take soo much time to create all 1 by 1. And make them complete set. I was wondering is there a action or way to do that to create rows to child tables inside the parent form when we creating it parent? I tried to create action but actions dont applies when we creating form as far as i know. I cant create columns to parent table such as part 1 part 2 part 3 part 4 . Because all products doesnt includes 4 parts always. It changes. Is it a action or easy way to create a grouped product all in once?

Check out the Data structure image. Thank you in advance.
Data structure

1 2 309
2 REPLIES 2
Top Labels in this Space