Question Selecting records to create a group which builds new table of data

[CliffACS]

I currently have a database with tables similar to the Northwind database whereby I have a Suppliers table and a Products table. I also want to build a Bundles table that bundles groups of products to show a total cost for each bundle. I am planning on breaking the Bundles table into two tables; Bundles and Bundle Details (similarly to Northwind's Orders and Order Details). Is there a way to create a form (instead of a report) that allows the user to select different Products to create a new bundle that can be named and stored in the Bundle tables along with an extended cost total of the products selected?

 

[neileg]

Your term bundle is usually called a bill of quantity or a kitting list. Do a search in these forums for lots of discussions.