Inventory Issue (Suggestions?)

[klynch0803]

I need some suggestions on the simplist way to handle somethign like this. i'm thinking my way may be the difficult way and I wanted to see if anyone had any better ideas.. ANY SUGGESTIONS would be greatly appreciatted..!!

I have a database that has inventory of each and ounces as well as it has some items that should deduct some items from one qty. Here is my example below maybe someone can help me out with some suggestions on how to maybe make this happen systematically without using a bunch of direct reference code as I already have code to add and deduct inventory on a each basis but not in the instance I need below i have newly discovered.

I was thinking about a checkbox in the table "Liq" and write Code that if it is true then another box on the inventory deduction form would show and show the values dblSht, singlesht, regSht, HlfSht and depending on one selcted would determine the actual qty deduted. Therefore to deduct a 2oz shot from hseLiq in the example below you would select HseLiq (in the standard inventory list) in one box and then the second box would show up and you would select DblSht in it therefore adding one record "HseLiq" Qty "2" else it would follow the regular method.

Below is the items and what they should deduct from:

BudBtl deduct from BudBtl (normal)

Here is what is tricky:

I have house Liquor "HseLIQ" that I need to add to inventory which would be easy if it was the only item but when it is deducted is would be deducted as follows:

Item = Actual Item Deduct From

HseLiqReg = HseLiq
hsedblsht = HseLiq
hsehlfsht = HseLiq
hsesht = HseLiq

MidLiqReg = MidLiq
Middblsht = Midliq
Midhlfsht = Midliq
Midsht = Midliq

PremLiqReg = PremLiq
Premdblsht = Premliq
Premhlfsht = Premliq
Premsht = Premliq