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