I set up a mysql database with address information. I want to create some
mailing labels. However, every time I set them up, all I get is the
database fields in the labels and not the data. (Openoffice 2.0 on
Linux).
This is what I did:
1. Created two tables in a mysql database - one with the names/addresses
and one with the dates I have mailed to them. These two tables are linked
by a name_id field.
2. In Base I created a query that selects the data from the names table
based on a criteria in the other table. I tested the query and it works
in the design view. Something like - SELECT * FROM Names, Sent WHERE
Names.name_id=Sent.name_id AND Sent.year=2005
3. I selected new from the file menu and then labels.
4. I selected the database, table, and fields for the label, then selected
new document.
All I get in the labels are the names of the fields and not the data from
the table.
Any suggestions would be greatly appreciated.
You don't appear to have selected "Data to Fields" This is the command
that populates your document!
Peter HB
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
