I have a Canvas app with SQL server connection data source. Let me define the problem by example.
Assume two SQL tables can join together with a foreign key like:
Table A
Account# | Name | Status
111 OfficeSuply 1
222 AppLicense 2
333 Hydro 3
Table B
StatusName | Code
Accepted 1
In process 2
Pending 3
Hence, the status on table A is a foreign key to table B having the actual value.
Now, when I create a form or gallery view to modify, update, or show the records, it will edit the numeral values and not the associated one on another table.
What is the solution for this?
