sorting problems

[smitheroosky]

Is there any way to completely remove sorting so that data is stored in the order in which it was entered on a form? I had to use to two forms (with the first containing a subform) because the information was too long for one. The important piece of information is the name of a course, and when I finish the first form it stores it alphabetically (so when the person clicks the command button to complete the second half, the wrong record appears unless you are entering in data strictly alphabetically).

I've tried using a new field called entry number, but the subform does not automatically recieve that information and store it like it did with just the course name. I've tried playing with the relationships and with the primary key, but that did not change anything. The ultimate solution would be one where I could just use the course name. But if I have to use the entry number and the user only has to type it once, that will do. Sorry if this isn't very coherent, I'm a little fried right now. Thanks.

 

[The_Doc_Man]

If you have a primary key on the table, it ALWAYS appears in prime key order. The only way for it to do otherwise is to remove the key. Which might have negative side effects.

 

[RichMorrison]

One more from the peanut gallery.

Doc Man and Pat are not really contradicting.

Data is STORED in entry order, or FIFO if you prefer.

Data is DISPLAYED in primary key order in datasheet view.

RichM

 

[smitheroosky]

Thanks for the help and information, everyone. I was able to get the autonumber to do what I needed. So, I finally have the db functioning the way I want it. It may not be the best design in the world, but I'm a psychologist by training and had to learn Access while doing this project. What I was actually referring to with the information being too long for one form was that I could not seem to make the form longer than 21 or 22 inches, and needed more space (if there is a way to do that, let me know for future reference). The actual tables are nowhere near 255 columns.

Anyway, I just want to thank all of you for the help. Without a few of the answers I got here (to my messages and others I read) I would probably be in hiding and trying to establish another identity in a foreign country by now. Take it easy.

Dave