I'm new to Access and working on a sales and inventory database. The inventory products have retail and wholesale prices; the wholesale prices are not percentages of the retail prices. I would like to have a structure that enables creation of an order form where I can select either the retail price or the wholesale price for each line item. Is this possible, and what might be the best structure? TIA