Update page deleting entire record
I have an admin page that updates a products/lube relational table by using foreign keys from a products table and a lube table (using the Manage Relational Tables server behavior).
When I attempt to update the product type checkbox list (from grease to engine oils, for example), it updates the product/lube table primary key to a value of 0, resulting in a 'this record has been removed' message.
The Lube and Product foreign keys update correctly.
The site pages are included and can be viewed live (see PM).