views:

3378

answers:

1

I have a dataset that has two tables in it. I want to do the following (or something like it) is it possible and is how I have it correct?

        dsTabData.Tables("FilingTabs").Select("fs_ID not in (select fsp_fsid from ParentTabs)")

how do you reference data from other table in the same dataset?

+1  A: 

ok ok before y'all flame me! ;)

I did some more looking around online and found what looks like the stuff I need, now off to read some more from here:

Navigating a Relationship Between Tables

MikeScott8