Creating form from tables with 1 to many relationship

App Building
1

Hello,

I have a requirement to generate form from tables with 1->Many relationship, and user need to submit the form, when submit the PK,FK relationship on the table should be populated. How to create a such a form?.

2

Hey @Parthib_Rathinam!

After generating the form you might try switching out the input corresponding to a select component. As long as you set it's form data key to match the column name of your foreign key it should slot in to the generated query automatically:

From there, you can populate it by creating a separate query that reads from the table the foreign key is pointing to. That way you can populate the select with the correct values and labels from that table. You can read more about how to do so in the docs on option lists.

Can you let me know if that works?

3

Hi Kabirdas,

Excellent. I will try and update you if any issue.

Thanks,