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:
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 !