I have someone working on a DB I created and the code they need to use requires that the datatype be short text and for some reason, I may have had it set to memo. So he asked me to check a few of the fields to make shore it's set properly and change it if it's not. However, when I get to the Sharepoint list to take a look, I cannot find the ID columns. For example, when I go to sharepoint and view the list. tblProdLine, I can see ProdLineIDbut when i go to edit list it doesn't show as a column so I can't get to the data type or column type. OldID was something I used when I originally imported the data so that's not it (or shouldn't be).




Click image for larger version. 

Name:	Image 18.jpg 
Views:	12 
Size:	69.9 KB 
ID:	30219Click image for larger version. 

Name:	Image 19.jpg 
Views:	12 
Size:	97.7 KB 
ID:	30220