Dear Helen,



Some >200 fields in record for table animal.



Select *

from Animal

ORDER BY ANIMALIDENTIFICATION



Is the select statement I use.



Now to implement above



Select *, (select L.description from Location L
where L.LocationID = a.LocationID) as Loc_Name

From ANIMAL etc wont work.



Do I now have to type all the fields into the select statement.



Shew, this is why I was hoping for a simple property to set the relation.



Is there a easier way to set up above?



Thanks

PS as mentioned, many lookups so many such relations have to go into the
SQL?



Adrian



[Non-text portions of this message have been removed]