I need to enter grocery coupon info into a database. Will require the following fields tables:
Manufacturers:
MfgID(PK)
Manufacturer
MfgPrefix(FK)
MfgPrefix:
MfgPrefix
MfgID(FK)
Brands:
BrandID(PK)
MfgID(FK)
Brand
Varieties:
VarietyID(PK)
BrandID(FK)
Variety
Details:
DetailID(PK)
VarietyID(FK)
Size
Unit
Pkg
UPC
Coupon:
CouponID(PK)
Barcode
MfgID(FK)???
BrandID(FK)???
RequiredPurchase**(ask me)
Qty
Get**(ask me)
ExpDate
I need one form to be able to …