>>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?