This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

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

Posted on 06-23-2023 07:53 AM
lucasferreira
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

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?

0 1 87
Topic Labels
0 Likes
1 REPLY 1
Top Labels in this Space