AnsweredAssumed Answered

Vendor Solution Needed

Question asked by Bricktop on Sep 15, 2010
Latest reply on Sep 16, 2010 by philmodjunk


Vendor Solution Needed


Hi All,

I'm making and invoice solution with me being the middle man. I need a field to show the price based on vendor choice and Item. All the items are the same, but the price varies per vendor daily, weekly, monthly. My first soultion I made each item id unique with different daily,weekly,monthly, prices. It didnt get good feedback because it made them items list way to big. 10 items * 5 vendors = 50 things to sort through.

I need to able to pick an item (not unique), pick vendor (from a list), and the the  field will calculate the price based on start date and end date. I hoping to do this using a line table. Im hoping somone can help.