Sorry, the UT parser gobbled part of that -- I'll try again ...
SELECT < parent fields you want > ;
FROM < parent table > ;
WHERE < parent primary key field > = ?lcChildKey
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?