cmdTemp.CommandText = "SELECT Models.*, Categories.*, Hair.*, Eyes.* FROM ((Models Inner join Categories on Models.CategoryID = Categories.ID) Inner join Hair on Models.HairID = Hair.ID) Inner join Eyes on Models.EyesID = Eyes.ID Where CStr(Models.Code) = &#039" & ModelCode & "&#039"<BR><BR>I am actually interesting from the Where CStr....<BR>I am trying to display with asp these fields but i get the id numbers instead of the text.Why?<BR>Thanks