I'll try to explain again in a little more detail as my previous response doenst actually cover everything.
I have a grid that is generated from a table that for example looks like this (simplified a lot):
id: Integer which is a foreign key
name: varchar
When I declare the grid, the id is not editable, I do not want it to be changed for any existing rows.
When the user wants to add a new row I need to do two things…
1) Id needs to be present in the edit form which it isnt, presumably as the field it not editable in the main grid
2) There might only be one id in the grid, but the user must be able to select from all of the id's in the foreign table, so I guess I need to do another lookup on the foreign table?
Im just not sure how to achieve this, I can't be the only person to have needed to do this so I am guessing it's possible but my lack of knowledge is the problem here.
.
