Is this possible with just pure DataSets?

[ghsmith]

I know I can do this if I'm using a real database and queries. I don't
want to assume the presense of a decent engine on people's machines so
I'm trying to use just the .Net Framework (ie: DataSet).

Among many other tables/fields/etc. I have...

I have a "Members" table which is unique by Group_Name+Player_Name.
ie: Lists which players belong to which groups.

I have a "PlayerHistory" table which is unique by
Player_Name+Scenario_ID. ie: Lists which scenarios have been played by
specific players.

I have a "GroupHistory" table which is unique by
Group_Name+Scenario_ID. ie: Normally would be a join result.

I want to have a Count expression column in the GroupHistory table that
involves the other 2 tables. Namely, I want to get "count of players
of this group who have played this scenario".

Is this possible with just pure datasets and expression columns?

 

[Cor Ligthert]

GHSmith,

In my opinion should it be posible.

When we have a datarelation, than we know the count of the childrows which
you should be able to use in an expression.

However I never tried it.

I hope this helps,

Cor

 

[ghsmith]

But in this case, I need the results from consulting 2 tables - not
just one. I'm doing child based expressions in other columns but they
are only referring to 1 table. I may well be possible, I'm just not
sure how.