Existing Virtual table and relation with new table

[KubaL]

Hi, I would like to ask you about some scenario in Model Driven App. I would like to create new table, let’s say Customer. Next I want to connect this table with another table for example virtual table integrated with Business central which has data already. Connection should by established by custom field. Do you have any suggestions? Thx

[Mira_Ghaly]

@KubaL 

Please have a quick look on this article it may help

https://robertostefanettinavblog.com/2020/11/20/business-central-virtual-entities-and-cds/

[dpoggemann]

Hi @KubaL ,

You might want to check out the documentation for this following in preview from Microsoft (https://appsource.microsoft.com/en-us/product/dynamics-365/microsoftdynsmb.businesscentral_virtualen...) 

Hopefully this helps you setup what you are looking to accomplish.

Please accept if this answers your question or Like if helps in some way.

Thanks,

Drew