Yes, the ID number is automatically assigned by Access, and I use it as a link to establish a relationship between two tables containing different kinds of information for the same records. Let me be more clear: In Table1 I have as fields the IDNumber, First Name, Last Name, Address information, etc, about a list of students. In Table2, I have as fields the IDNumber, FirstName, LastName (same as in Table1), and other fields related to academic performance of those students (I used different tables for this because I was asked to do so by my Computer Science teacher, since this is a school project).
The problem is that when I enter a new record (new student) in Table 1, there is no record appearing for that student in Table2. Is this supposed to work this way because of security reasons I don't get? Because if it is, then I will have removed the "Autonumber" option for the IDNumber field, and just change it to "Number" and make the user assign an IDNumber for each student, I'm just so tired of it not working!! (I'm using Access 2007, by the way).