Multiple table Dataset - Synchronising data

[DeanWilliams]

Hi,

I am new to .NET. I am using VB and have a dataset with 6 tables in it. A child table of the primary table has parameters set on it. This is set by a userform. When the user chooses dates, the relevant table is filtered, but the other tables still display all the original data. How do I synchronise the other tables? I have set up the relationships, but they still don't filter.

Please help.

 

[macleod1021]

If I'm understanding your problem correctly, you grab everything from the database, then apply a filter to the first table. Then when that filter is applied, you want the related tables to "drop" the unneeded information. Does that sound about right?

If that's the case, you'd need to set up a method to filter the other tables through code. The relationships allow you to mimic the rules that the database would impose.

However, I'd recommend a different approach to getting what you want. By getting all of the information initially, you're really hurting your performance. I would suggest getting a subset of information from your table (enough for the user to make a choice on filters), then do a second query to bring what they want.

For instance, in the case of ordermaster and orderdetail tables. Query the ordermaster detail based on customer number. That will give the user a list of all orders. Then when they choose a ordernumber, do a second query that brings the orderdetail rows into a second table.