you need to create the fields that are for the FK as lookups on that entity, and then associate those records with the lookup field, that will create the relationship you need to for those 2 entities.
hope that helps
Can this be done at the time the data integration for the child table is done? If not, can it be done in bulk following integration of the two tables using Power Query? I have a child table containing over 20k items and it is impractical to relate each item one at a time.
I have been struggling with bringing a large dataset from an outside database into CDS while maintaining the relationships between the tables. It has even been stated that it is impossible to do it. https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Creating-Parent-Child-Relationship-... I have just posted an article in the Community blog https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/bg-p/PowerAppsBlog with a step by step method for accomplishing this with illustrations of the steps. It might be cumbersome but it is possible just using Excel with the built in Power Query, PowerApps Common Data Service. Kudos goes to @SeanHenderson for the original idea.
I followed the link to your article in the COmmunity blog on how to create the relationships, but am unable to find the right article...🙄.
I also would like to etablish relationships between tables for imported data from SQL Server into the Dataverse.
I made it work!😀
As I will be importing about 25 tables from SQL Server with also approximately the same number of relationships it would be nice if you can script this, instead of doing it all by the GUI. Make it repeatable.
Any ideas or suggestions over there?