Hello, I hope someone of you guys can help me figure out what to do here.
So, I have a grid with inline edit that has as data source the table "Shifts". In editing mode, between the various columns, there is one that must be populated according to another.
In practice, the column "Project" has a relationship with the column "Client". And the latter has a relationship with the table from which I take the "Shifts" data. When I go into edit mode I need to be able to populate the dropdown of "Project", with the correct data, based on the selected "Client".
I don't know how to load the correct data during editing whether I do a single edit or multiple edits.
Hope I've been clear enough, the following is the DB structure.
Shifts Table (Used to populate the grid)
- ShiftsId PK
- ShiftsClientId FK
- ClientId PK
- ProjectId PK
- ProjectClientId FK