December 18, 200916 yr 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?
December 18, 200916 yr 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.
Create an account or sign in to comment