>>>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.
>
>I have never, yet, used views in SQL Server. I will make a point to read and learn. Right now I am trying to make my app work on either SQL Server or VFP, using pretty much the same table structures and code. Thank you.


Dmitry,

This is an example how to add po_Freight and po_SalesTax calculated fields to PO, summing them from the invoice table

	create cursor po ;
	(	po_id		I, ;
		po_vendor		c(30), ;
		po_date		D, ;
		po_amount		Y ;
	)
	
	insert into po values (1, 'UT', date(), $100)
	insert into po values (2, 'Google', date()+1, $200)
	
	insert into po values (3, 'Microsoft', date()+2, $200)
	
	create cursor invoice ;
	(	inv_id		I, ;
		inv_po_id		I, ;
		inv_Freight		Y, ;
		inv_SalesTax	Y ;
	)
	
	insert into invoice values(1, 1, $20, $20)
	insert into invoice values(2, 1, $20, $20)
	
	
	insert into invoice values(3, 2, $20, $20)
	insert into invoice values(4, 2, $30, $30)
	
	
	
	select	;
			po_id, ;
			po_vendor, ;
			po_date, ;
			po_amount, ;
			nvl(po_Freight, $0)		as po_Freight, ;
			nvl(po_SalesTax, $0)	as	 po_SalesTax;
		from po ;
			left join ;
				( select ;
						inv_po_id, ;
						sum(inv_Freight) as po_Freight, ;
						sum(inv_SalesTax) as po_SalesTax ;
					from invoice ;
					group by 1 ;
				) X;
				on ( po_id == inv_po_id)