Designed a new query with all the related fields, rebuilt my former based on that. Deleted the old form and it works good. One question though, once related and normalized my data base my order got out of wack on my primary table. It runs in blocks about 4. 43-70,23-42, 1-22,and 71-106. What would make it down that. It cured itself for a few minutes then went back. Not a big deal but annoying.
Reply from Alex Hedley:
Try a compact and repair. Are you ordering it by something other than your AutoNumber?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 1.
