I think I'm falling in love with you, all of you. Deanna, thank you so
much, that worked perfectly.
Kind regards,
CK.
On 19 Aug 2004, at 2:05 pm, Deanna Schneider wrote:
> I'm not sure I'm following you, Chris. But, are you saying that you're
> currently passing the projectname, but you need the projectid? If so,
> you
> can display the projectname and pass the projectid. On your form,
> just do
> this:
>
> <select...>
> <option value="#projectid#">#projectname#</option>
> </select>
>
> ----- Original Message -----
> From: "Chris Kavanagh"
>
> !
> >
> > Luckily, I'm nearly finished, but I have another stupid question for
> > you lot, my new favourite people.��I'd like to insert values from an
> > insert form into two separate tables.��I'm planning to use a SQL
> insert
> > like this:
> >
> > <CFQUERY datasource="myDatasource">
> > INSERT INTO tasks(taskname,deadline,notes)
> > VALUES('#taskname#','#deadline#','#notes#')
> > </CFQUERY>
> >
> > In my backend Access database I have a relationship between two
> tables:
> >
> > TASKS PROJECTS
> > Project --> projectsID [key]
> > projectname
> >
> > The insert form gets all the "projectname"s and puts them in a list
> > box.��But how do I go from there to inserting the corresponding
> > projectsID value into the tasks table?
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
