>Farouk-
>
>>We have almost done on this project when the client ask for last minute addtion. We have a lot of transactions screen which use view compound from the transaction table to the master table. Example : Employee Master and Leave. The compound view use the a parameter field in employee master to filter off the records. Now the client request to get another field from a 3rd table, service history. What is the quickest way to do this? To do the conventional way, I will need to look at all the screens and the views and change the views to include this new parameter. Is there any faster way?
>
>Is it literally a view? Is it defined in a DBC? If so, then you should only need to change the view. If you've copied a SQL statement into multiple forms, then, you'll have to search. If you're using VFP 8.0 you might be able to do a search and replace across the project (Tools | Code References). If this is the case, I'd urge you to consider changing your approach and start using a view if you're not already. They don't have to be updateable. Also, I've found Stonefield Data Toolkit (www.stonefield.com) to be a worthwhile investment, if that's a possibility for you.

Thanks Lisa for the info and sorry for the late reply. I am using views. In fact the developer has done the views and most of the screens are using this views. He has asked and insisted in me using the filter property in the cursor DE instead of him changing the views. I'm doing this in the Load method and all the views have NoDataOnload =.T. and I think it will not work. Does view ever use the filter property to further filter? Does Requery will use this filter again? My test does confirm my view but I may have miss out something.

Thanks in advance.