>Are you talking about view in SQL Server or VFP? And how would a view help in this case?
>
I was thinking of SQL Server view, although it will work for VFP as well. We don't want to have calculated field in a table using UDF (as we need to base calculation on another table). The better solution is to use a view where this will be calculated.