Search results

Spikepl for the most part there is a common percentage used for item classes but I still need the ability to change one product if need be to make it more competitive in the market. I will try the way you have suggested John, but i am just worried about the maintenance side of things if i had...

I understand the structure you have proposed but i don't understand how this would work for more than one customer. Are you suggesting that i have a record for each productID and CustomerID? Example under tblCustProdPrices : Customer1 - Product1 - Price Customer2 - Product1 - Price etc...

Hi John, Essentially the idea is to streamline our pricing process, currently the task is carried out by a 100mb excel sheet that is incredibly slow. The master table basically just holds the data, there is no calculated values in this table. I have the item number, the item base price and...

Hi All, I have created a query to price items for me for specific customers. So far i am able to choose a specific customer, products and the base price associated with those products but now i am stuck with the discount rate that is specific to each customer. I have a combo box on my form...

I got it work, thank you for your assistance paul.

Hi Paul, I would like the query to ouput the all of the item numbers that were entered. For example if I decided to fill out three texts boxes with 3 different item number all for the same customer, I would like the query to output 3 lines with customer name and the corresponding item in the...

Hi Everyone, I have created a pricing database to let me price specific items for specific customers. I have created a customer and and item table independant of each other. Right now i just want to return the Customer Name and the Item Number specified. I have made a form that has a combo...