Still having an issue getting the Manage Relational Tables to work. Maybe it is not designed to work like I think it is but here is what I am trying to do. Maybe someone here can point me in the right direction.
I am inserting a product into the database with one form. There are the fields for the the main product information then there are the fields for the product options. In the options there is a checkbox that is using the Repeat Selection behavior to be displayed.
I have inserted an Insert Single Record behavior for the fields that describe the basic product and have them written to one table. This is working okay.
I have an Insert Multiple Records behavior for the remaining fields because they could choose more than one checkbox and for each checkbox checked it would write a new record to a second table. This is also working fine.
When I add the Manage Relational Table behavior is where I am having an issue. I want it to write to the third table the Key columns of the other two tables so I can associate the product with its options. I can not get this to write to the third table.
Support told me to remove the redirect from both Single and Multiple Insert Records. When I tried I get the same results as above.
Does anyone here have any suggestions?
Thanks,
Bknvc1