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!
Fernando España
SQL Server Specialist