In my test project there is one basic table (Table1) which contains an autonumber field (long integer) and also one more field which contains a description (text).
There is also Table2 which consists of an autonumber field, a foreign key related to the autonumber field of Table1, and two date...