Hi all I have an order entry databse which deals with order taking & Invoicing & Manufacturing Report.
The thing is I have 35 Lines (ie products) but different customers pay different rates.
A discount field is not Suitable.
Will I need to create a table for each customer?.
I aint done much with access until recently,
so I need my hand holding a bit, current customer base is 30ish. and the prices can all be the same as onthe current price list, Any ideas guys.

Thanks
Mark