Inventory & Orders

[matt_v]

I'm creating a inventory/orders database. As prices are different for each distributer, I'd like to select the distributer first on creating the order, then have the database look up the price for that item for that distributer. I've attached what I've got so far.

Thoughts?

Thanks,

Matt

scg_inventory_relational_pricing.zip