Hi Guys,
I have a table call InventSummary which contain ItemID,InventSize,Inventcolor, QtyOnHand,StockValue,SalesQty,SalesAmount I have created view call InventTransView its shows ItemID,InventSize,InventColor,SalesQty,SalesAmount
When I try to do update it's not working. The syntax is
Update InventSummary
Setting SalesQty = InventTransview.SalesQty,
Salesamount = InventTransview.SalesAmount
Where InventSummary.ItemId == InventTransView.ItemID &&
InventSummary.InventSize == InventTransView.InventSize &&
InventSummary.Inventcolor == InventTransView.InventColor
Please let me know where I have done wrong.
Thanks
Jay
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
Yahoo! Groups Links
http://groups.yahoo.com/group/development-axapta/
[EMAIL PROTECTED]
