Order form for bundled products

[LQ]

Hi,

This is for Access 2003. How should I setup an order form for products
ordered in a bundle or individually? The bundled products are ordered as a
group but priced & listed on the report individually.

The main form has client and shipping information. I would like to link it
to the subform thru the OrderID.


I was planning on using two subforms.

The first subform would include

SKUID
SKU#
SKUDescr
Quantity
OrderID

Another subform would be linked to the first subform on SKUID. It would
show the products associated with each SKUID.

ProductName
Mfg. Part#
Item description
UnitPrice
ExtendedPrice (calculated field)
GL Acct.
lngSKU

The system generates the two subforms as long as I limit the fields.

Product.ProductName
SKUProducts.lngSKU
SKU.SKUID
SKU.SKUNo.
SKU.SKUDescr

I’ve setup two separate subforms based on queries, but I get an error
message saying if I want to link the two subforms, I need to include
SKUProdID. I added it, and the system wants to link the subforms on the
ProductID and not on the SKUID.

Is there a way to enter the quantity on the first subform so it
automatically fills a quantity field for each item on the second subform?
This way I can include a calculated field to extend the total price for each
item.

If there's a better way to go about this, I'm all ears.

I appreciate any suggestions you may have.

 

[Arvin Meyer MVP]

If you add a field in the table for BundleID and allow it to use duplicates,
then you can add a bundle as an individual item and take the BundleID as a
group. Other ideas may be available, with a sample in the following:

http://www.mvps.org/access/modules/mdl0027.htm