My second question as the first was not answered, may be because it was too long.
I am trying to add new and update records in two different tables. Currently the data from the parent table is displayed on the page whereas the child tables's data is displayed using an iframe.
This makes it tricky to add a new record when both these sections are connected via a primary key:ProductCode.
I am strugling with this and need your help in implementing two different functionalities on this page.
1. Adding new records
Where the parent and child tables will both have a new record entered.
2. Updating existing records
where the record currently displayed on the form can be updated.
Ok this is the scenario i am trying yo make it work.
1. User clicks the Add New product button. Result: all the fields on form would become blank so the user can add new info. This includes the iframe. Once the user has finished entering the data, he/she would click on submit changes and then the data would be passed through to the savechanges.cfm file.
2. User clicks on update product details button. Result a new row is added within the iframe data so that the user can add new data for the particular product being displayed on screen. Once the user has finished entering the new data, he/she would then click on submit changes and then the data would be passed through to a savechanges.cfm file.
I am not sure how to go about this. I have managed to display the data but i really need to ass this functionality of adding and editing data.
All help and ideas on how to achieve this will be highly appreciated.