Business Alerts sales order details

[josiahjg]

Hello:

We are trying to get business alerts to send a sales order email to the customer when a new SO is generated. Everything works fine, until we introduce the sales order lines (table SO2). We get an error:

Error 20109: Primary keys are not unique. Duplicate key =

I have tried linking tables every possible combination, but have not found the solution. Any ideas? Unique Fields has both SO1 and SO2 SalesOrderNumber (tried it with just one table as well).

Thanks for any help or pointers in the right direction!