I'm starting a new job on Monday and sometimes I will be doing the receptionist type job role. It requires using Databases and I am really confused about the relationship part of it. How do I decide which field I should make the relationship too? If You don't understand what I mean please can you just let me know all the information you know about using relationships in Microsoft Access 2007. Thanks, much appreciated guys.