Amateur Questions

[Bacnka]

Hello

I'm at University and have been set some coursework in Access to do a variety of things. The guide book I've been given isn't very good and talks to you in a way that assumes you already know how to use Access.

I'm not sure which forum this should be in, I apologise if it's in the wrong one.

I've been given a database which has a lot of information about books in it. I've been told to create a list that contains the title and author of books only from Belgium.

On the starting panel, I've pressed New, Table Wizard and added the fields I want to this new table.

I specify there is a relationship between this table and the original one. When I type my BookID into the new table, a + symbol comes up that contains information from the BookID from the original table.

When I go back to my starter panel and click on relationships, my new table doesn't appear.

I may not be making much sense, purely because I don't know how to use the application. However, I'm asking whether or not it's possible to link the information from one table to the other instead of copying and pasting.

I hope this makes some sense to people.

Thanks.

 

[John Big Booty]

Assuming the DB is normalised all you should need to do is create a select query to draw together the information you require. There should be no need to create a new table.