About autoserial and relationships

[thegreek]

I have made a table that every time that a record is created it gets a serial number.I have made a relationship with the other main table to display the newest created record.It works as i want till i get to the number 99(I started the autoserial at 00)when i make new records above 99 they dont show to the other table.What can i do to overcome this strange behavior?

[Hijack]

Just to confirm, your serial number field is a numeric field and not a text field, right? it sounds like it's simply sorting the serial data textually instead of numerically.