Vendor Solution Needed
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.