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]
