Admin update page not showing correct data
I'm adding an 'Industry' checkbox list and a 'Testimonial Company' text field to an existing admin Update page. Can't seem to get the correct data to show up on the Update page after clicking the pencil icon.
In the Industry checkbox, only the fourth record shows as checked, even when there are multiple records and the fourth one has been deleted. Not sure why it would only show one, or the fourth rather than the first. I've looked in three places for the solution: Update Multiple Records SB, Managed Relational Tables SB and checkbox value attributes. In the Update Multiple Records wizard, I've tried binding to either the form, session or recordset with no change. It seems like a 'value' attribute issue, as it looks like there's some old validation text in there, but don't know how to strip it out, then locate the correct value. Tried looking at the MRT, but not sure how to troubleshoot it.
In the Testimonial Company text field, I can get it to show the correct ID by using a session variable from the Insert page, or the actual company name (first record only) by using the recordset. But can't get it to show the company name from the correct record. The Update Record binding is set using the form's text field name attribute.
DW page attached.
