MySQL Logic and Recordset Problem

On 11 Jun 2007 in macromedia.dreamweaver.appdev, OleLena wrote:

> - I am using the DW8 insert record "wizard"
> - I have a table called 'blue' with 3 fields (id, text1, text2)
> - I want the user to enter info into a form (1 field) -- the text1
> field is a pulldown select
> - I want the user entered data in the text1 form field to TRIGGER an
> auto insert of the text2 data, and then enter both text1 and text 2
> field data into a table called ''red" on submit
> - Assume that my form is setup correctly and that the form works and
> passes info from page1 to a results page, and that my tables (blue
> and red) are setup correctly
>
> How do I do this ?

The better question is why do you want to do this? It sounds like
you're entering redundant data - in other words, for every time you
enter 'banana' in text1, you enter 'eaten at breakfast with cereal' in
text2? Either enter it all in text1, or extract it using a join on
output.

> .....LOL...I cannot figure it out ..Your help
> with putting EXACTLY what I need to in the recordset dialog
> box (on the results page) would be GREATLY appreciated......

What exactly are you trying to do?

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php