I have a table called ItemList and a table called ItemVendor. Item list is a listing of all parts. Items cannot be duplicated. ItemVendor is all the possible vendors for the items in ItemList. Based on lowest price to highest price, I want to automatically set the vendor ranking.
Item Vendor Price Rank
MM-01234 XYZ 4.00 2
MM-01234 ABC 3.00 1
Without allowing duplication's of vendor rank. You cannot have Rank 1 for the same item and vendor.
Any Help would be appreciated. Thanks