>Hey Cindy
>
>Wow I like that lookup() function, now thats a time/code saving function


Yep! It became one of my favorites very quickly once I saw Anders Altberg using it in a newsgroup post. Saves on setting relations between tables, among other things.

I read a lot of newsgroups looking for functions (and other tips and tricks) I otherwise haven't heard of or used much. It's been pretty worthwhile and I've learned a lot very quickly.


>
>>>Way 2… in query statement, call a function that gets the DESCRIPTION…example
>>> SELECT ………….get_desc(arg) AS fld_description…..
>>
>>
>>Robert - read about LOOKUP() in the Help for getting the description.