run two queries from one click?

[Bob Wilson]

This has to be easier than I'm making it. I have a form with these
fields:

TaskID - number
Task Description - text
Month Completed - text list pulled from a query
Year Completed - text list pulled from a query
Category - text list pulled from a query, can be more than one
category per task
Task Description - memo

Now what I want to do is...

insert TaskID, Description, Month Completed, Year Completed and
Description in one table

AND

insert TaskID and each Category into another table with a single
button click to make it easy for users. As stated above, there can be
more than one category per task.

I have done this on the web with middleware handling the data passing,
but this is working directly with the database and I can't seem to get
the syntax or something. I think I'm making it harder than it should
be.

Of course any alternate approaches that would make this better are
welcome also.

Any help is very appreciated,
Bob Wilson

 

[Guest]

If your first table is setup so that the TaskID is the primary key field then
set a one-to-many relationship the the TaskID in the second table with
referential integerity and cascade update.
Then one query with the two tables in a left join to feed a form/subform
will do it.