[grahampage]

Thanks for the reply Bob.

If the planner tenders the shipment then I does an insert into this table, but how do you them determine that the carrier selected on this tender was not the next best carriier that has not refused the load in the past. For example, If SWFT is the 5th cheapest carrier for the shipment and it has already been declined by JBHT and HAEI who were 1st and 2nd cheapest then how to I catch the planner who picks SWFT and bypasses the 3rd and 4th best carrier in cost?

I just see that the record in this rable tells me who the planner chose and not whether the planner made the right choice.