Hello. This is my first post on this forum, I'm not even sure whether this is the right forum for the question. If it's not, please redirect me to the right forum.
So I have a form which is used for displaying and maintaining data from a Setup table. The table has a field named SetupMainAccount, which is related to the system table MainAccount through its field RecId. The field shows Account Number from the MainAccount table, but the client also wants to see the Account Number value in a separate column. So I've done it by adding MainAccount table to the form's data sources, along with my main Setup table, and specified the relation between the two data sources. The MainAccount data source's properties Allow Create, Delete and Edit are all set to No, because I don't want any data from this table to be updated through this form. I have then added the MainAccount.Name field to the data grid, and everything looks fine initially. The problems begin when I change the Account number value from the dropdown in the grid, and try to save the record, the following message pops up:
Does anybody know what causes this message. I have not called this function, but I have found that this function is called from the MainAccount table class's update method. It probably means that update of MainAccount table's record is attempted, but how can I prevent it?
