Creating a relationship between two tables

[amyhannah]

I need to be able to make a relationship between these two tables.

I have a student table and then an instructors table - I'm making a driving lesson booking system.



I have included a picture of the two tables I have made so far.

I want to link it so that when I am on the Instructors table (which holds all of the booked lessons) I can see the information of the student who has booked the lesson underneath.

I am fairly new to Access so any help would be very much appreciated.

Thank you.

[rpeare]

I'd suggest you modify your table structure to be more normalized.

1. Student Table (the table you have is just fine, just remove the chosen instructor)
2. Instructor table (a table with your instructors, and any information directly related to them with an autonumber PK field)
3. StudentInstructor table (a table with an autonumber PK, a FK to your student table and a FK to your instructor table)

In other words on your table that is currently 'mel jones' you would, instead of having the student first and last you would just store the student ID, the student and instructor information could be looked up by linking your instruction table to your student table, and the student table then linked to your junction table and finally to your instructor table. It may seem convoluted but as you're doing development it'll be far easier to record all this information 1 time than to keep repeating it in multiple tables.

[orange]

Amy,

I agree with rpeare's comments, but I'm also suggesting a tutorial that will lead you from a Business description, to identifying entities and attributes, tables and relationships. The tutorial will elad you though these steps. It has answers also. I think it will help you with concepts that you can then apply to any database.

see http://www.rogersaccesslibrary.com/T...lationship.zip