Links

Hi Nigel, thank you for the post, in answer to your question, linking tables is probably the most important part of creating and using an Access Database (well I think so anyway)
We link our tables by using the relationships window. There are three types of join that we can use in linking; One to One, One to Many and Many to Many. Access does not like the Many to Many join so it is necessary to create a join table which has the primary fields from the two other tables, so your create a many to one, and a one to many which makes a many to many if you get what I mean. (Difficult without diagrams.) We join our tables by connecting a Primary Key field to the same type and kind of field in the second table, so if you have for example a table which holds all the department names, and another table which has all the employees in a company, if the employee table has a field which has the department ID in it, joining the Department table; department ID, to this field by dragging and dropping it on top in the Relationships window will open the join dialog box, confirm your selection and click Join, you can then create a query which has information from both tables and the fields will display. I hope that has helped, best regards Pete