Hey i im making a program in vb6 and i need some help. I have 2 tables (students) and (teachers) and i want to make a table called contacts that displays the number of student or number of teacher (they can never have the same number its like a system you register a student he has X id and the teacher Y id and X and Y will never be the same). Well my problem is that i join the teachers to contacts and students to contacts both on a 1-1 relation. When i try to add a contact for any student or teacher it says that the other table students if i try to add contacts of a teacher or vice-versa if i try to add his contact info :/ I don't have any other option other than making a contacts table for students and another for teachers. Is that the solution? If so, am i able to JOIN both tables? Thanks