Parent and Child Table Relationship

[Jeff_Hager]

Possibly…

Assuming you are using a native glide form, you could add an On Submit action that adds an extra row to the child table, but it will need to be a custom action, and it would need to check if a child row already exists for that supplier or not. That’s where it gets a little more complicated and fragile. I prefer using a custom form at that point. You would still need a custom action on a submit button with conditions to add rows to both tables or only one table depending on if a supplier row already exists in the child table.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…