Nabil,
Yes, that is correct. In most cases, you don't want to pull down every category and supplier, only those that pertain to the product that was chosen. In most cases, it's best to minimize both the amount of data that you pull across the wire and also minimize the round-trips back to the server ... sometimes you have to walk a fine line as to what will give you the best performance.
~~Bonnie
>>>What is the best practice in retrieving the data of a table and all related reference tables. For example the table [Products] in northwind database and the related reference tables [Categories] & [Suppliers].
>>>Create one dataset with all three tables?
>>>Create three datasets?
>>
>>Well, I think that´s create one dataset with everything... we can think of a dataset as a DataEnvironment in VFP...
>
>What about if I want to populate the Categories & Suppliers data in a comboboxes, so every time I retrieve data of a different product I have CLEAR and FILL (REQUERY) all the data of Categories & Suppliers tables again. Is that correct or am I missing something?