Fixed Assets - Registration Product table wrongly defined
Description
Test case:
Add one record in "Registration Attributes" window
Navigate to "Product" tab and add one record for "Azalea"
Add a second record for "Seeder"
Now go back to the "Azalea" record and try to change the description and Save
Error: Could not save changes: Update return 2 instead of 1 - [POSaveA_RegistrationPro_7256ec19-42d7-4bdb-9a68-ae51a182dfdc] - A_RegistrationProduct.A_RegistrationAttribute_ID=1000000
This is because the table is wrongly defined.
If is a one-to-one extension table then it must ensure to allow just one record per attribute. If is a one-to-many children table then it must have a primary key not based just in the parent key (probably a SeqNo?)
Test case:
Add one record in "Registration Attributes" window
Navigate to "Product" tab and add one record for "Azalea"
Add a second record for "Seeder"
Now go back to the "Azalea" record and try to change the description and Save
Error: Could not save changes: Update return 2 instead of 1 - [POSaveA_RegistrationPro_7256ec19-42d7-4bdb-9a68-ae51a182dfdc] - A_RegistrationProduct.A_RegistrationAttribute_ID=1000000
This is because the table is wrongly defined.
If is a one-to-one extension table then it must ensure to allow just one record per attribute.
If is a one-to-many children table then it must have a primary key not based just in the parent key (probably a SeqNo?)