Hi everyone,

Ok, I hope I can be thorough with my explanation....In my VB.net 2005 app have a databse with 2 tables - structure as follows:

[u]Dept</u>
    DeptID (PK),
    DeptName

[u]Documents</u>
    DocumentID (PK),
    DocumentName,
    Active,
    DeptID (FK on Table1)

Now, I have pulled in these 2 tables into my Dataset. In the dataset designer, I add a column to Dept and call it NumberActive (this is supposed to be a count of rows where Documents.DeptID = Dept.DeptID AND Documents.Active = True)

In a listbox bound to DeptBindingSource, another label on the form is supposed to be bound to NumberActive, so everytime the Listbox's SelectedIndexChanged event fires, the label will be refreshed with a count of Active documents for that department. Unfortunately, the label shows as '0' when I the form loads or when the selected index changes.

The expression that I am using for the in-designer-added column, NumberActive, is as follows:

Count(Child(FK_Documents_Dept).Active) = True

I have not done any additional coding behind the scenes, and I'm not sure if its necessary? Getting nowhere also searching Google.

Any help with this would be very much appreciated !

Thanx guys/gals!
- Shalan