You mean fields [not controls]? In your original question, were you trying to get all records from several tables with the same data structure into one cursor using SQL? If so, Mike was correct in that you need to do this with a UNION or by:
select 0
select * from table1 where ... into cursor crsTemp nofilter && read-only cursor
use dbf() again in 0 alias crsMyCursor && new cursor is read-write
select crsMyCursor
use in crsTemp && close original cursor
append from Table2 for ...
append from Table3 for ...
etc...
You can not use the View designer to create complex views [e.g., ones with UNIONs].
You can then design your report to use this crsMyCursor
>I can see that everything I need to accomplish the task at hand is in the view designer, what I need to do is manipulate the controls in the view designer with the controls on my REPORT FORM. Am I right in my thinking?
>
>>>In the form, open MyView with the NODATA clause.
>>>
>>>I'm not really clear on how to do this.
>>
>>2 ways:
>>
>>use myview nodata
>>
>>OR...
>>
>>Add the view to the form's Data Environment, set the NoDataOnLoad property of the view to TRUE. In the BeforeOpenTables method, include the following:
>>
>>set talk off
>>set deleted on
>>set exclusive off
>>set multilocks on
Mark McCasland
Midlothian, TX USA