>I will have dozens of different reports. I am not very experienced in the Properties Box. I Would like to be able to find an explaination, the logic behind the relationships and order. There are so many properties and some of them react violently when tampered with. What ever you find, keep me in mind! Thanks!
Robin, it's redundancy to use views for reporting pusposes, especially having separate view for each order setting. The reporting is job for cursors with their WHERE and ORDER clauses compiled programmatically, like this
DO CASE
CASE ...
cOrderstring="name"
CASE ...
cOrderstring="id"
CASE ...
cOrderstring="account_number"
ENDCASE
Select ... From ... Into Cursor tmp Order by &cOrderstring.
Edward Pikman
Independent Consultant