I made a view based on a OAT Query that joined the VendPackingSlipTrans table with the PurchLine table and group them by the PurchId and the ActivityNumber fields to sum Qty and AmountMST. I used the view in a form and I realized that the view is not being group by the PurchId and the ActivityNumber fields. I went to see the view directly to the SQL Database and see that the physical resulting view adds all the fields to the group by giving an unwanted result. Is there any way to avoid this?
