Append Query - Need Help!

[Fred Worthington]

Greetings:

I am trying to use an Append Query to combine the Names and Addresses from
the ContactInformation table with Training Sessions and Dates from the
ClientTraining Table into a single table (PostCardTable) that I can use to
merge data in a Publisher document.

Here is my problem:
The Training Session Field uses a query as the row source. The query is
used to sort Training Sessions from the Training Table alphabetically in the
drop-down list of the form field. Even though the Training Sessions appear
by name in the ClientTraining Table, when I run my Append Query to the
PostCardTable only the Training ID appears. If the Training Session does
not appear by name in the PostCardTable, I cannot post it in my reminder
card. A little sage advice would be greatly appreciated.

Thanks . . . Fred

 

[John Vinson]

Greetings:

I am trying to use an Append Query to combine the Names and Addresses from
the ContactInformation table with Training Sessions and Dates from the
ClientTraining Table into a single table (PostCardTable) that I can use to
merge data in a Publisher document.

Here is my problem:
The Training Session Field uses a query as the row source. The query is
used to sort Training Sessions from the Training Table alphabetically in the
drop-down list of the form field. Even though the Training Sessions appear
by name in the ClientTraining Table, when I run my Append Query to the
PostCardTable only the Training ID appears. If the Training Session does
not appear by name in the PostCardTable, I cannot post it in my reminder
card. A little sage advice would be greatly appreciated.

Thanks . . . Fred

Two suggestions:

It's just as easy to Export a Query as it is to export a Table (to
*most* programs - I'm not absolutely certain about Publisher). And you
avoid all the bloat and overhead of running a MakeTable or Append
query storing data redundantly.

Secondly, you appear to be yet another victim of Microsoft's
misleading Lookup feature. Your ClientTraining table APPEARS to have a
name in it - BUT IT DOESN'T. It has an ID, which is concealed from
your view by this misdesigned and all but useless wizard!

You will need to create a Query joining the ClientTraining table to
the Training Session table, joining by the sessionID; select the
session name from the table where that name actually exists. And get
rid of your Lookups, and use Forms to enter data rather than table
datasheets!

 

[Fred Worthington]

Thanks, John! That did the trick. I have Publisher 2000, and it doesn't
appear to offer the option of merging data from a Query. But, thanks to
you, my table is working just fine now.

Fred