I have an application that was created in Microsoft Visual Studio Lightswitch with a SQL backend. I am now recreating the app in Powerapps and want to migrate the database to Dataverse. However, I’ve hit an issue with one of the relationships between the tables.
I have 2 tables, Stocks and OrderDetails which are related many to 1.
However, when I look at either table in SSMS I cannot see the foreign key reference column in either table.
The relationship is showing in the Keys on the table.
enter image description here
The database diagram shows this:
enter image description here
The application built on this database is able to use the relationship so it is working somehow.
Any ideas how I can get the tables to actually show the related ID so that I can export to Dataverse?
Many thanks
All other tables in the database are showing the relationships
user24853966 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.