N-Tiers - Dataset typed and more ...

Hello,


In a n-tiers application, I used a typed dataset.

In this dataset, I have 2 tables "Orders", "OrdersDetail" and "Product".

Orders
- OrderNumber
- FullPrice
- ProductID


OrdersDetail
- Price
- Quantity


Product
- Code
- Name
- description

In the dataset designer, I have 3 tables with thieses fields, it's correct.

But for an order, I need all the detail and I make a join with product to
have some detail more in the result of the query.

But when I do that, some fiels of the product table are duplicated in
OrdersDetail. Is it normal?


Best Regards,

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com