Hello, I have upload many sql tables as sp lists. I did that using an excel-vba statement: list.Publish ... In the main table, many number fields are actually lookup fields. The lookup values are defined in auxillairy tables (lists now). I would like to convert these "number fields" to "lookup fields", if possible. In case this is not possible, how could I automatically define these relations when I create these list again. Is is possible to upload from sqlserver, instead of xl, and keep track of the relations? Thanks for your suiggestions, Michel