When I do a search on my lookup value by name I get no value but if I use the ID field I get the value. So how can I search by the name field instead of the id field? Any help MACK
Mack, I would recommend to use INNER JOIN in SQL query in ASPRunner to pull lookup values from joined tables. In this case you will be able to search for lookup field value.