Hi everyone,

Ok, I know this is more a General IDE question so sorry if I've posted this in th wrong forum. 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 similar to a T-SQL statement: ...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 nowehere also searching Google.

Any help with this would be very much appreciated !

Thanx guys/gals!
- Shalan

I think you need something more explicit to use count(), such as: What you posted would be the syntax to make Count = True, an assignment that isn’t really meaningful, of course.

Hi Brian,

I thought I could just construct an SQL query like that, but unfortunately the expression property for the datacolumn in my dataset designer does not allow actual T-SQL. Furthrmore, I am using SQL Server Compact Edition as my database, but I do not have the ability to construct nested queries on any of the tables.

regards
-shalan