I want to create a simple table. It's going to be an inventory table. It has an auto number field that is the primary key and will be the part number. It includes the size of each item in a separate field. This could be a single number in feet or inches, or something like 4' x 8' in feet or inches. I want the sizes to be in order as I view the table. Say I have 20 records entered, then need to add a new part that is in between a couple sizes that have already been entered. Is there any way to insert that item between 2 records that have already been entered? I don't care if the primary key field is in order? This is just something simple, quick and fast so I'd like to avoid writing queries if possible because that's a weak area for me anyway.
Thank you for any advice!!