Append Query Include Subdatasheet

[soccerelf]

I recently created a database that my office uses for tracking projects. The
problem that I have been having is trying to create a append query that will
allow me to transfer data from the main table and subdatasheet to another
table with a similiar subdatasheet. The object of this database is to track
the ongoing projects and closed projects within the office. I would like to
know if it is possible to create this type of query, if so and ideas or
suggestions that will allow me to start this would be appreciated.

 

[Ken Snell \(MVP\)]

You'll need to use two separate queries. One to append data from the "main
table" in the main form, and the other to append data from the
subdatasheet's table.

 

[Larry Daugherty]

It sounds like your use of Access nomenclature may be inaccurate and
that you might be simply using tables to interact with the data..

You should be using Forms and Queries to interact with the data and
never let your users even *see* the tables.

Please post back with a more complete description of what you're
trying to accomplish in the real world and how you're going about it.
Please include a description of your tables including their fields and
datatypes.

There are a couple other Access newsgroups that you might also find
instructive:

microsoft.public.access.gettingstarted
microsoft.public.access.tables design

There's a great resource for Access developers at

www.mvps.org/access