>Can I prevent the table alias name from being included in the field name when dragging and dropping an element from the data environment table viewer? LastName instead of Employee.LastName. I know I can manually open and remove it, but wanted to supress it if possible.
>
>Thanks
Daryl,
You can't because you are dragging and dropping the field form the cursor and the alias is part of its name. The only thing you cand o is to edit the expression for teh controlsource and remove the alias.
The bigger question is, Why do you need to eliminate the alias?