I have a virtual table "DevOps Project" that I would like to link (many-to-one) with the Dataverse table "Project". If I add a Lookup field "Project" to the "DevOps Project" table, I get an error
"ExternalName is null or empty for attribute 'project' of entity devopsproject"
I also tried to make a "many to many" relationship between "DevOps Project" and "Project", but that option is greyed out...
I made a custom "Many To Many" in-between dataverse table, with two lookups "Project" and "DevOps Project", which works fine, but is a bit overkill...
Is there no other way to link virtual table with a dataverse table?
