Setting Initial Value in Nested Form Based on Child Form's Value

[lucasferreira]

I have 3 tables:

1. Projects
2. ProductGroup
3. Products

A Project has multiple ProductGroups, and a ProductGroup has multiple Products. However, the Products are related to both Projects and ProductGroups through the columns ProjectID and ProductGroupID, respectively.

When I'm in a Products Form and fill in the Ref field for ProductGroupID but want to create a new ProductGroup, the ProjectID field in the ProductGroup form is empty. However, I would like it to "pull" the same value from the ProjectID field in the Product form.

Is there a way to do this?

[Tommy62]

Schaue mal folgendes Video als Lösungsvorschlag: Das Schleifen mit Aktionen in AppSheet ist eine äußerst hilfreiche Fähigkeit, insbesondere wenn Sie ...