Hi! Thanks so much for the patience. I appreciate I might not be explaining things too well since I'm still new to this. Unfortunately, I cannot take a screenshot of the powerapps and db as they I am working on a copy of actual data. I'll explain here as much as I can using some screenshots I made.
1. This is how the datatable looks like. It shows the actual product name and uses the view.
2. Then this is the editform. The value it will display is a product ID.
Another table manages the relation between the product ID and product name. In the DB, the ID is set to INT while name is VARCHAR. We programmed the view in SQL to display names based on product IDs from editform source table.
So basically, I should pass the value of the selected item in the datatable to the editform. However, the editform then should display the productname selected from the datatable instead of the productID based on the Products database. Then when the form is submitted, instead of product name, it would just pass the ID back to the editform's source table since the variable holding it in the DB is an INT. The view will then adjust accordingly.
Apologies for the very long explanation but I hope I made it more clear 🙏
