Hi Richard thanks for the great tutorials on Access, but i am a little stuck on one topic. What i am trying to do is make a database to record my Book collection. I have made a Book table with the author and book title and various other data. But because i want to be able to pick the publisher and book topic from a list i have used the combo box to pick from a table i have made with the publisher name. Following your tutorial in Access 103 part 5 the lead source i can make a combo box and select the data from the publisher table and it displays on my main form ok with the publisher name, i have also made a field on the main book table to store this data in, but i only get the id number stored not the name book field and when i try and print the report all i get is a number how do i get the publisher name to print please.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.