Hello Gary

Thanks for the help. Arghh one simple error for a property and everything falls apart. At least I was able to see that I did the right things from what you told me. I just had to do some changes and everything is allright now. At least at this point in my development <g>


>Denis:
>
>Did my earlier suggestion help regarding BeforeOpenTables? You never do say <s>.
>
>>This is not really the best approach because if the control source changes I'll have to change every reference in TextBoxes, grids...
>
>Quite so.
>
>>What should I do?
>
>Well, for example, your use of the lv_ViewName refers. That specifically implies you are using a local view. In Codebook, an lv_ViewName or an rv_ViewName could be used (depending on whether the view was local or remote) but an alias of v_ViewName was applied. So, this way, the view source (local or remote) could be switched on the fly with no changes to the forms.
>
>In your case, with CM7, all you need do is define the workarea alias (see the builder) to some generic name that effectively abstracts the actual name of the cursor type's data source.
>
>So, go ahead and use a Work Area Alias name which will allow you to switch the underlying data sources without causing any recoding.
>
>Personally, with views, I tend to call the view work area alias v_ViewName while the source view may be called lv_ViewName. In this way, you can distinguish between local and remote versions of the same view as an added side effect but still code to an alias of v_ as opposed to lv_ or rv_ .
>
>With native tables, call the work areas something meaningfull but not the table name itself. In this way, you can use the same CDE/Forms on cursors based on the tables, not necessarilly views, maybe SQL-Select(ed) cursors, and alias the cursor(s) with the work area alias names you have specified.
>
>HTH
>
>-=Gary