How do I go about adding records to a linked table? For example, in my previous post I have a "contacts" table, a "source" table and a contactSource table. A contact can have one or more sources, so contactSource is basically a table with 2 columns, ContactID and SourceID. These two columns make up a compound primary key.
I have a form that allows me to enter some contact details, firstname, lastname, email and select a number of items from a list of sources that are in my Source table. The form returns a comma delimited list of SourceIDs that I need to insert into my contactSource table. Normally I would set up a transaction, add the contact and get the new contactID and then run through the list of sourceIDs and add them to the contactSource table with the new contactID. I'm not sure how to approach this with reactor. Any assistance would be much appreciated. Regards Stephen -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
