Hi there, we are starting to develope a purchasing database and I am a little confused about setting up the product pricing. I have suppled a partial of the inventory we have. starting at row 5 these are accessories. the top 4 are main products. I have thought about lookups but can't get my head around it with the current formats. Then i thought if I filter out the products based on product number and category then do the lookup that would work. Again, I then thought that I should set up two inventory tables one for main products with a lookup for 5 price levels and one table for accessories. Not entirely sure which direction to go. I believe that the inventory should be in one table...i could use an if / case formula to lookup the price. see lots of ideas.
Thanks in advance