Hi Wes
Thanks for replying.
>It's been a while since I fixed a similar problem. I think it was cured by breaking a relation that was set in another part of the program. Sounds really strange, but I think that was the cure.
>
>Let me know if it is.
>
I fixed it after posting the message. However, the problem was caused dependent on the user status who logged on. Certain users run startup programs. If the startup found certain conditions, a relationship was established that should have been cleaned up after the process, but wasn't (guilty) <s>. The process that fell over used files for new relationships that were involved in the hungover startup relationship. When that was broke, the data type mismatch occured as you predicted (what a Guy) <g>.
So another part of the system was fixed as a result thereof. If I hadn't investigated the relationship that I saw in the View window, I would still be scratching my head, had you not replied.
Thanks again Wes.
-=Gary