I've got a strongly typed dataset, one of the tables in the dataset has a
UID column ( integer, primary key ) and a TIER_ID column ( integer,
nullable ). TIER_ID references UID, but when I add a data relation to do
this the fill method hangs..
The top level record has a TIER_ID of NULL it seems that this is causing the
problem, if I update TIER_ID on this row so its not null it solves the
problem, but causes alot of junk in the dataset as somewhere along the line
you have to have a row with the same UID and TIER_ID, which means you end up
withodd rows in the dataset.
Has anyone ever come across this ? is there a solution ?
TIA
Mark