Putting identical form fields into database

[Donalo2000]

I want to add a new entry to my database..

I have the form with all the fields ready.

However for one particular field, i want to have a drop down list of what's
already in that field in the database (not a problem, a new recordset, with
DISTINCT set works fine) .
However what i also want is to have a field beside this that will allow the
user to add their own category if it's not already in the databse.

So, how can i get the insert behaviour to insert whichever of the two fields
the user has selected??

I've named both fields the same, the drop down and the text entry, but that
just seems to confuse matters!

Any help is greatly appreciated.

Donal
:beer;

[Paul Whitham TMM]

If you have two fields with the same name, the insert will take both values
and separate them with a comma which is not what you want.

What you need to do is write an IF statement that tests the second field for
a value and if one is found use that on the insert.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Donalo2000" <webforumsuser@macromedia.com> wrote in message
news:d0naus$22o$1@forums.macromedia.com...

> I want to add a new entry to my database..
>
> I have the form with all the fields ready.
>
> However for one particular field, i want to have a drop down list of

what's

> already in that field in the database (not a problem, a new recordset,

with

> DISTINCT set works fine) .
> However what i also want is to have a field beside this that will allow

the

> user to add their own category if it's not already in the databse.
>
> So, how can i get the insert behaviour to insert whichever of the two

fields

> the user has selected??
>
> I've named both fields the same, the drop down and the text entry, but

that

> just seems to confuse matters!
>
> Any help is greatly appreciated.
>
> Donal
> :beer;
>