How can I ensure that the parent IDs from my users table automatically populate in the parents table?

Hello, I am an intern at HorizonSport, a sports organization that offers sports camps during holidays for children and teenagers. I have not been able to make the parent IDs (which are located in the user_id column of my users table) automatically populate in the parent_id column of my parents table.

What does the flow look like to add a row to the Parents table? Maybe we could add the user_id at the same time you create a new row with a user profile column

Or…
If there is a common key in the parents table and user table then you could create a single relation from the parent table to user table and then add a lookup column via that single relation

1 Like