johnf schrieb: > On Monday 11 May 2009 03:59:20 am Sibylle Koczian wrote: >> I tried this, and now the dDropdownList is filled correctly, I get no >> error messages - but the parent-child relation doesn't seem to work: the >> grid for the child records always shows the records belonging to the >> first parent record. > > I didn't see anything in the code that looked wrong so I would start doing > some debugging. > > I have a guess that the problem is the dropdown is changing but the record of > the 'rubrik' is not moving. So you can prove it. >
It's even worse: the record of the "rubrik" bizobj not only doesn't move, it gets the key of the record just shown in the dropdown. And that key is the primary key of the table. Wonderful. Luckily I haven't done anything about saving yet. It's clear I made quite wrong assumptions about dDropdownList (and about the other list controls?). I thought moving through the choices list would move through the records of the dataset and show the content of the current DataField, but instead it seems to put the current value _into_ the DataField of the current record, which doesn't move. Right? > First open a dShell (contrl-d). Many thanks for that advice, I hadn't discovered the dShell yet! > Check to see if the value of the dropdown is changing. Most likely it is. > Check CurrentSQL for 'dinge' and make sure that the where is changing or is > not changing. At the same time check the 'rubrik' dataset and see if it's > changing. > Value of the dropdown changes, where clause in CurrentSQL for "dinge" doesn't change, current record of "rubrik" dataset doesn't move (but gets a wrong value in its PK field, see above). > If the above proves correct then I would write a little code that fired as a > result of the dropdown that will set the where clause of either of the two > tables. Then requery() > I think I'll use a dGrid with one column instead of the dropdown. Saving space isn't really such an issue here, and it might even make the application more comfortable. We are talking about a database table with 14 records here. Thank you, Sibylle -- Sibylle Koczian _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/4a083ad8.80...@t-online.de