Hi! In the attached sample project I have three tables:
names: id,name
roles:id,role
namesroles: id,nameid,roleid,thename,therole (these are of type fkLookup)
and three unidbgrids to CRUD the data
everything is ok with the two lookups but one thing fails whatever I try to do:
when I update/insert/delete an entry in names the corresponding dropdown in in the namesroles grid is not updated... any ideas? as you can see in TDataModule1.FDQuery1AfterPost I tried to open/close all involved DataSets, change indices (any many more things I deleted meanwhile) withou success...
test_unigui_3.zip
test_unigui_3.zip