Hi everybody,

I have 3 Datasets based on TableAdapters: Orders, OrderDetails and Inventory. I have 3 Biz objects using them as well.

Now, I want to create a list of categories. Assuming I don't have an extra Categories table (and extra TA/DataSet), can I re-use my Inventory TA for this?

I got a warning about TableSchema when I added a query select distinct Category from Items and so I'm a bit worried if I can have Biz Obj method returning a datatable of categories this way.

What do you think should I do?

Thanks.

Ok, I spoke with my colleague and we're going to go with the separate Categories table, so I'll set it up and will use a new TA/DS (but probably the same Biz object).