I understand that you cannot mix base table fields and table extension fields in a table extension key - the base table fields do not exist in the extension table.
But what about the primary key fields of the base table? They are duplicated in the extension table and still you cannot use them in the table extension key.
Example:
Table extension extending "Sales Line" with a field "My field"
It shoud be possible to create this key: key(ExtensionKey; "Document Type", "My field")
because the field "Document Type" is part of the primary key and therefore exists in the extension table
Succestion: Allow using primary key fields together with extension fields in a key of a table extension.
Comments
We need to have the opportunity to reduce the slowness of BC.SaaSWe need to be able to create mix keys like we did for OnPrem.
Category: Development
It would be very useful to be able to define secondary keys that include fields from different extensions in Business Central. This would facilitate data integration and improve flexibility in table management. I support the proposal that, at the very least, it should be possible to include primary key fields from the base table together with extension fields in a table extension key.Thanks
Category: Development
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