So, I was kind of wondering how those using carrierroute where populating their routes. I was hoping to build a cost table that contained the costs for all our routes and all our carriers, and then construct the carrierroute table as a view derived from the cost table. I guess my SQL (and those around me I asked about it) isn't that good, because I haven't been able to come up with a way to do it yet. Doug. ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com