I would love to figure out how to do this:

Have a view page with an Insert Page behavior added that will allow me to add all text fields from the queried record to another table.

Can this be done and if so, HOW?

Please help!

Frenzy

There's nothing really special about this. You have a recordset which you'll use a REPEAT REGION and possible Recordset Navigation to view the data, and below it, a form that you apply INSERT RECORD behavior to. What more are you looking for? If it's step by steps on this, it would be best to read up on a UltraDEV book.

Most of the time we ask "how-to" on oddities that aren't easily done in UltraDEV. If I know what you're wanting, there's nothing too special in how to get that result.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Thank you for your kind reply but I have unsuccessfully tried this to no avail.

I am trying to take the form values of a viewed record from table1 and by adding an INSERT behavior and session variables, take these values and insert them into a new record in table2.

So far, I have been unsuccessful in this endeavor. I have traveled wide and far in my online research for a solution and have used this forum without finding a solution.

Your feedback alludes to an easy solution but it isn't as easy as you have replied. I would love to see a working solution...

Here's some reference material to provide an overview of what I've so far done:

Possible relevant links:

www.macromedia.com/support/ultradev/ts/documents/passingformdata.htm (How to pass form data from an insert, update or delete page)
--------------------------------------------

And this is how I have unsuccessfully tried to create a view page with an insert behavior:

1. Select INSERT --> LIVE OBJECTS --> MASTER DETAIL PAGE SET to create:

a. Master Listing page of all records in table
b. View page to view specific record

2. Add INSERT --> LIVE OBJECTS --> RECORD INSERTION FORM

I also created a session variable for EACH form value so that I could pass along the value from the viewed record to the INSERTION FORM.

I have been miserably unsuccessful in this attempt and respectfully request help from anyone who knows the solution to this issue and possibly a working copy of such a solution!

ANY Help is APPRECIATED!

TIA


Frenzy