Saving Linked Table

[Bill T. Ray]

I have a table that is used to link books and authors. I think I originally
downloaded
the Access file from the Microsoft examples, possibly for books
but maybe for some other collection set. I have made some modifications over
the months or years. The three fields in the table are: BookAuthorID,
BookID, and AuthorID of Data Types: AutoNumber, Number, and Number
respectively. When I view the table it views as BookAuthorID, Book (not
BookID) and Author (not AuthorID). Here's my problem. I want to save this
table as an Excel file so I can take it with me in my PDA. But, when I save
it as an Excel file it saves the data as BookAuthorID, BookID, and AuthorID
so I get a spreadsheet with all numbers, no book or author names. When I'm
at a bookstore looking for new books and don't remember whether I have that
particular
book, a bunch of numbers is not a lot of help. I am using Access XP (2002)
on WinXP Pro.

Any suggestions on how to
save the data as book and author names would be appreciated.

Bill

(e-mail address removed)

 

[Douglas J. Steele]

The database must be using the Lookup Field that so many of us despise for
reasons like this.

Create a query that joins that table to the other two tables so that it
returns the Book and Author names rather than the IDs, then export the query
rather than the table.

(Sorry: I have no idea what the actual database looks like, so I can't be
more explicit than that)

 

[Larry Daugherty]

Hi Bill,

If your original source was a Microsoft sample then it very likely has a
report so that you can print the entire list. If not, you should design
one.

HTH