Search results

Wow!!! Incredible jdraw! Thank you so much for your very detailed explanation! With your input I was able to finish the program! I am very happy. Regarding your remarks about storing the price: I understand what you are saying. However for this program it is not a problem. The customer more...

Sorry for the confusion in naming. Please see the screenshot, hopes this explains. There is never a default price. So there is only a price when this is explicitly added (in CustProdPrice). But since order details can be added without them having a price I need an overview of those without a...

Hi! Im almost there. I used a somewhat different approach now (still based on the DB scheme from update 10) 1. Orders (and orderitems) can be added all the time, for some items there will be (customer) prices for others there won't (yet). 2. There is a specific form where prices can be added...

Yes clever approach! One big 'but' though: "You need to populate the table CustProdPrice" That was _exactly_ what I was trying to avoid or make at least as easy possible :) (from my first post). All Products are in 'Products': and I want a form with those exact products and be able to add a...

The price for a product for a customer is set (that is the point, because of the mistakes ;)) Maybe this clarifies things a bit: Theoretically the price for the product for the customer CAN change. But this is not really a problem because every month all orders are "run"/closed and copied (with...

That situation is actually where Im coming from :) But this was too prone to errors because people that didnt know the right prices (or made mistakes) had to add the orders (mind you there wasn't a current retail price). So the manager asked me to have an input form that only he could control...

Hi jdraw, see the first attached file (I recreated the db in English en cleaned it up a bit). I'd like to know what you think. To answer your question: Can a Customer can exist without having Purchased a Product? - YES And I believe you are saying a Product can exist independent of an...

Hi jdraw, thanks for explaining the junction table. I think I understand the concept (I didn't know it was called junction though). You learn something everyday :). This lead me to a link on a foresightsoftware dot com page which also explains it nicely (I can't link URLs because of my newbie...

Hi, I'm new here. (I have been doing a little bit of Access designing on and off for ~10 years now. Nothing too fancy but some people are very happy with their Access program and use it everyday.) I have a challenge with a price per product per customer setup. Have a look at my table layout...