I am trying to make an inventory/sales database in Access and VB6. Its for my computer store. Here is the case:
Usually we have sales offers in our store. For example, for a complete PC system, we have different offers depending on hardware. Usually the price range changes with better configuration, e.g, more RAM, bigger Hard Disk, etc. Now I want to implement these offers in such a way in Access Database, when we enter the data for any sale, we dont have to re-enter all the hardware, quantity, price etc, again for each offer, as a particular offer has always same hardawre components/quantity/price. Usually if a customer wants to buy a PC system, based on his own choice of hardware, we would enter the data in SALES table in each field for each peice of hardware(e.g,CPU, Monitor type, RAM, HDisk, keyboard, etc,etc) being sold, as well as quantity and price. I have implemented this easily. But for those special offers(which customers mostly buy from out store), I want to automate the data entry in such a way, that when the customer wants to buy any of our particular offer, we just choose the OFFER code from combo box
or drop down list, and the SALES table is automatically accumulated with data from that particular OFFER.
How to implement that in Access and Visual Basic 6? Any Ideas?