>>I am experiancing a very perplexing problem in my code. I try to execute the following line of code.
>>
>> USE Home ALIAS MHome
>>
>>and get ALIAS NOT FOUND three times.
>>
>>This line of and several other similar lines work perfectly.
>>
>> USE Employee ORDER Id ALIAS MEmployee
>>
>>All the files exist in the same dictionary file. If I remove the ALIAS portion of the command it works and in spite of the error message it opens the table and assigns it the correct alias.
>>
>>This is VERY confusing and I can't seem to track it down. I thought it might be a referance to "Home." in an index but I cleaned them all out and it still persists. Validating the database brings up the same error but completes with a Database Valid message.
>>
>>Thanks for the help in advance
>>
>>Terry Hobart
>
>I'd guess that you have three index tags which refer to the alias Home. So when you open the table with alias MHome, the tags refer to an alias which doesn't exist.
>
>Solution: don't put < Alias. > Field in your tag definitions unless you're sure the same alias will always be used. (Translates to, don't put alias in the tag, you can *never* be sure.)
>
>HTH,
>Rich.
Yup that's what the problem was. I just spent two hours removing aliases from all my tags in all my tables. I know there is an option somewhere to set the expression builder not to include these but I haven't been able to find it yet.

Thanks for the help
Terry