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.