robn
Posts: 70
|
| Posted: 06/01/2007, 7:11 AM |
|
I have an issue that I am trying to resolve.
I have a large record form with 20 sections on it all containing the basic same data (report, Issues, Comments and Actions). What I am after doing is on insert or update instead of having to update create one large row of data with all the fields on it I want to normalise the data. I intend to do this be having one table containg the record ID, Record Name, User name and Status. Along with another table that has a foriegn key to the Record ID (RID) and holds the sections number and the rest of the basic data (report, Issues, Comments and Actions).
But I struggling to find a way to update / insert mutiple rows from a record along with updating two tables at the same time. If anyone has any ideas how to do the above I would be most grateful.
I'm currently using ASP and SQL 2000.
Thanks in advance
Rob
|
 |
 |
smalloy
Posts: 107
|
| Posted: 06/07/2007, 2:53 PM |
|
I've done this, I did it by using a CUSTOM INSERT, using a custom insert you can use a view or a stored proceedure! ts that easy. Click on your record and then select the Data tab in properties, look toward the bottom and you will see "Custom Insert", user the elypsis (...) to find the view or stored proceedure.
There is a newat little wizard to help you ad if you search Custom Insert in the CodeCharge help (F1) there is more info too.
Steve
_________________
Anything can be done, just give me time and money. |
|
|
|
|
