Okay, sounds a bit over my head at this point but if I that is what I have to do I will figure it out.
But before that do you think this would work. Have a page that inserts the basic product information and then have another page that they select the basic product and then add the options required for that product. Could I then get the Manage Relational Table behavior to reconize the basic product's key and insert it into the relational table along with the option's key column as it is generated? Or is the issue that scince niether key column is known at the time of insertion that the data is not written to the relational table.
Just trying to understand.