I have a BIG problem. Hope you can help and point me in the right direction.

I need to create a form to manage products Inventory (common thing), but I need that a product can contain another products so this products is a package.

I have to tables, one for products with the usual fields (ProductID -primary-, Description, Price) and another Packages that has (PackageID -primary-, ProductID1 related to the ProductID of the products table-, ProductID2 that store the product for the package and quantity.

The idea is that is I create two products, the I create a another product that is a package, this will have the two products created first. I can sell the product alone or the package with the two products.

A ListView (similar two the old SampleCRMApplication in the OrderEntry form) is used to manage the products of the package, but I found I need two ProductsBO in the form, one for the product itself and another for fill the ListView.

As my database has some sample records, I test this, and "works" I can create and update products alone, and if the product is a package I can show the products that are part of the package.

Is this approach correct? I  don't want to create the logic to load products to the package (same way as SampleCRMApplication OrderEntry) and then found that this was not correct.

Thanks for your advice.

Dropping a BO onto a form multiple times is no problems but I think (never tried it) you can have one BO that has multiple BBS associated with it.

I would imagine the first problem to solve is how you handle logically transforming product A and B into product C and handling inventory when these products are sold/returned.

Cheers, Peter

For an example of this, load the StrataFlix sample...it has a lot of good stuff there and shows how to do this.