So here I am, at the last line of defence, so to speak: my first app is
due today!
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?
Thank you for your continued patience with my stupid, basic questions.
Yours tiredly and confusedly,
CK
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
