Recent content by Sarita2710

Yes sure - I followed both of you and created a table for the category/discount and used a combobox for the user to select the category which when selection was made the After Update event filled the discount textbox with the appropriate discount value. Again many thanks for the help

Thanks everyone managed it. :)

Arnlgp - I need the customers discount to show on their records - depending on their category they get a certain discount which I don't want changed Thanks

thanks Colin - not sure how to do that but will give it a go.

OK what I would like to do is in my customer form which has the normal customerId, etc I would like to add a discount column where the value is set according to the category of customer e.g. if I select Retail the discount is set automatically to 10% Can any one give me an idea of how to mange...