Nabil,
That's correct ... you don't want to pull down all the data for every category and supplier at one time, only those that pertain to the product that is chosen. As I mentioned in an earlier post in this thread, in most cases you need to minimize the amount of data that you pull down at any one time. This is a classic client/server design issue.
~~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?