Forum Discussion
Rexter
Sep 26, 2023Brass Contributor
Dataverse lookup columns
I have a question about using lookup fields in Dataverse. I have been developing in Access using Dataverse as the data tables. In Access, using Lookup fields is not a good practice. Does the same app...
Rexter
Sep 27, 2023Brass Contributor
I got two differing opinions here, so I am not sure which way to go. Should I create relations using the Relationship Tool in Dataverse table?
George_Hepworth
Sep 27, 2023Silver Contributor
It's really up to you, in the final analysis. IMO, the interface for Dataverse tables is overly complicated because it tries to wrap the underlying realities of tables in structures like the Lookup tables and so on. After some initial attempts to incorporate Dataverse tables, I went back to the tried and true, i.e. SQL Azure or SQL Server.
Performance is not as impressive either. But ultimately, if Dataverse provides you something unavailable elsewhere, then it's okay.
Don't let others, who are either enthusiasts or skeptics, override your own experience.
Performance is not as impressive either. But ultimately, if Dataverse provides you something unavailable elsewhere, then it's okay.
Don't let others, who are either enthusiasts or skeptics, override your own experience.