I'm testing the master-detail grid of your 'demos' section. So, first of all I used the database.sql script in order to have the db tables to get the demo working.
The result is two nice grids that are interacting fine 🙂
The next thing I did, was selecting a record in the master table resulting in the corresponding records in the detail table, which is still fine.
I was curious what would happen if I tried to change the 'Id' of one of the detail records. So, clicked 'Edit' and changed the 'Id' to some other number.
When pressing 'Enter', the 'Id' number changed to it's original value again, which I think is a good thing because changing key values never is a good idea.
The problem is, when I'm trying to do this with two of my own tables, who look pretty much identical to the 'clients' and 'invheader' tables, the grid is not preventing me from changing the PK. The only difference I see between
the invheader table and my own detail table is that the name of my PK is not 'id' like yours but 'idinschr_kombinatie'. Could that explain the issue I'm having ? If so, that would mean the PK of the detail table has to be 'id' in order to work properly.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?