Hello community, need your help, please.
What I need to achieve:
For each new record created in the form linked to the table 1, a user should be able to select one or multiple values from Column A in the table 2. This I was able to achieve with EnumList and suggested values Table2[Column A].
Now, based on the selected values from Table2 [Column A], the app should automatically pick related values in the column B in the same table 2 and populate another field in the form.
Many thanks for any ideas!