G
Guest
Hi, I believe I asked this question before, but I can find no record of it
existing anywhere on any of the discussion groups, so I figured it best to
ask again.
I have a database that contains a pair of tables, meant to catalog books.
One table has the book titles, their author, an autonumber ID (to serve as
primary key, since there are books with the same name by different authors,
and different authors with the same name.), and an identifier meant to group
together books in a series. The second table has the authors' names, and an
autonumber ID (again, since there are identically or similarly named ahthors
who are in fact different people). This table was made so that I could create
a combo box in the books table that would populate that table's authors list
with the names from the authors' table (and make it easier to not only add
authors, but also to have them sort alphabetically within the list, and save
typing when adding a new book).
The problem I'm having now is that I want to make a report that will list
all of the books on a neat and printable page, and will sort them under the
heading of each author
example:
AUTHOR
-book 1
-book 2
-book 3
AUTHOR 2
-book 1
-etc.
Unfortunately, when I make the report, instead of getting the authors' names
to show up, I get their autonumber IDs instead, even though the field is
supposed to be the author name one. I've tried numerous ways of making the
report (base it on one table, base it on both, make a query and base it on
that), and all I get are the numbers instead of the names.
I know it has to be something simple that's wrong, but I just can't figure
it out for the life of me.
Thanks in advance,
Matt
existing anywhere on any of the discussion groups, so I figured it best to
ask again.
I have a database that contains a pair of tables, meant to catalog books.
One table has the book titles, their author, an autonumber ID (to serve as
primary key, since there are books with the same name by different authors,
and different authors with the same name.), and an identifier meant to group
together books in a series. The second table has the authors' names, and an
autonumber ID (again, since there are identically or similarly named ahthors
who are in fact different people). This table was made so that I could create
a combo box in the books table that would populate that table's authors list
with the names from the authors' table (and make it easier to not only add
authors, but also to have them sort alphabetically within the list, and save
typing when adding a new book).
The problem I'm having now is that I want to make a report that will list
all of the books on a neat and printable page, and will sort them under the
heading of each author
example:
AUTHOR
-book 1
-book 2
-book 3
AUTHOR 2
-book 1
-etc.
Unfortunately, when I make the report, instead of getting the authors' names
to show up, I get their autonumber IDs instead, even though the field is
supposed to be the author name one. I've tried numerous ways of making the
report (base it on one table, base it on both, make a query and base it on
that), and all I get are the numbers instead of the names.
I know it has to be something simple that's wrong, but I just can't figure
it out for the life of me.
Thanks in advance,
Matt