I have a self-referencing table (i.e. ER fish-hok or this kind of
(Field) Department ID : ID Type
(Field) Reports to : ID Type
The "Reports to" field will be either null (reports to no-one) or with
a valid Department ID (within the same table). Recursion 101 :-)
Anyway, when I insert into this table, the row goes in fine but the
Drop Down List Box i'm using for the "Reports To" field doesn't show
the new row. Even when I cause the parent (i.e. the datawindow the
DDLB is in) to retrieve, it still won't put the new entry in the DDLB.
Only when I close the window and open it again will the DDLB have the
new row. This makes some sense if a retrieve of the DataWindow the
DDLB is in does not cause the DataWindow of the DDLB itself to
refresh, but I need to in this case.
How can I tell the Data Window DDLB to re-read it's table?