Add more detail rows

[alhazen]

Hello,

I need your help. I have two tables called "hazard" and "hazard_data". "Hazard" is  parent and "hazard_data" is child.

is it possible to create form like this? I want the user to be able to add more rows for the detailed list based on the provided question. Thank you so much for your help.

[Aurelien]

Hi @alhazen 

*

In the table "hazard_data", get the column that refers to table "Hazard", and check the option "is a part of".

[alhazen]

Hey, Thank you for response. I've done that, but it hasn't lived up to my expectations. I'll use an enum list as an alternative

[SkrOYC]

Adding 2 cents to @Aurelien's right answer, each section of your image that has a "New" button is a different table configured with the "Is a part of?" option. So you need as much child tables as questions/"New" buttons expected

[Aurelien]

 @alhazen  a small addition to what @SkrOYC said, from my experience:

"So you need as much child tables as questions/"New" buttons expected"

This works for this kind of situation, with one parent having possibly various type of children or various children of one type.

However, a child table cannot have various "is a part of" parent, because that would lead to a conflicting behavior when deleting one parent table, which is supposed to delete a child item which is linked with "is a part of" to another parent table (I hope this last part is intelligible 😂)

[alhazen]

Hey, thank you for response.

There is only one child table which is "hazard_data", but it can't be done like I want

[SkrOYC]

The image you posted inside the OP is using  the "Is part of?" setup, if you need anything else you need to reexplain your need more clearly

[SkrOYC]

---

@Aurelien wrote:

lead to a conflicting behavior when deleting one parent table, which is supposed to delete a child item which is linked with "is a part of" to another parent table

---

It's like an "existence paradox" 😁

---

Anyway, it's also explained in the docs for reference

References between tables - AppSheet Help