Create a package deal

[Peter Simpson]

I need to create a facility where a customer can select a package deal.

I have a table listing my services. I want to select groups of services and name the Package1, Package2 and so on.



how do you suggest I go about it?

[ranman256]

you will have a tPackage table.
(1 record say is: Entertainment pack)
[PackID], [PackName],[Price], etc....
1234, Entertainment pack, $2000, ...

a sub table tPackItems will hold all the items IN the 1 package
[ItemID],[PackID],[ItmName]
1, 1234, Sony 60" Flatscreen
2, 1234, Sony Surround Sound bar
3, 1234, 200 watt amp

and of course, tCustomer table, tInvoices, tIncome, etc

[isladogs]

Tables as per Ranman's post.

You need 2 forms:

The first form is used to create packages:
Use a multiselect listbox showing all items available.
Have a button that appends all selected items to a specified package.
This will allow you to use the same items in more than one package

The second form is where users select the package they want:
Use a combobox or standard listbox showing all packages
Have another listbox linked to this showing all items in selected package
Add a button to confirm selection made

HTH