about your answer, the problem is a view must have a PK you can reseolve this problem adding a line number in your detail table.

Example:
in the next example
the error message iskey field is not unique..
IDMOV ITEM PRICE TOTAL
001 3555 3.50 3.50 *
001 3555 3.50 3.50 *
001 3556 2.25 2.25
* the information is duplicated! Error

This sample is OK.
IDMOV ITEM PRICE TOTAL Detail_Line_Number
001 3555 3.50 3.50 * 1
001 3555 3.50 3.50 * 2
001 3556 2.25 2.25 3
the line numer make the diference!.

Sorry for my English!, I speak Spanish.
Good Luck!