1
I would like the limitation for SQL virtual tables to be overcome so that you are able to use views (which are treated as tables without primary keys).
If views are able to be made into virtual tables then it should follow that they should be able to used as GUIDs right now the GUIDs get converted to a decimal value and hence do not work well to assign as lookups to other records.
Right now the only option is to duplicate data if integrating with On-Prem systems which places an unneeded space requirement for app builds.
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team