Doobeh Posted October 9, 2001 Share Posted October 9, 2001 Hi there, I'll give you a brief overview, I've just finished a database, and one aspect holds date ordered notes in a portal (note,date,user,id_no are the fields in the related file) The relationship is specified to sort the date desending. Okay. It works, when I enter a new note it gets shuffled depending on the date perfectly. But, and heres the kicker, I imported about.. 10,000 entries into the portal for the clients, for some reason the portal doesnt sort these entries, only new ones. Can you think why? The date is exactly the same format. So basically if i were viewing the portal for X client I might get: code: Gone Fishing Dean 27/10/2000 Went to meet Bob Mark 25/06/2001 Client agreed to work June 09/04/1998 Which obviously isnt sorting it, but if i then added 2 new entries [today and tomorrow] I would get: code: Gone Fishing Dean 27/10/2000 Went to meet Bob Mark 25/06/2001 Second Entry Doobeh 10/10/2001 First Entry Doobeh 09/10/2001 Client agreed to work June 09/04/1998 So you can see, it sorts my new entries, but totally ignores the old ones. Any ideas you can think of, it's probably quite easy (or I hope it is), but I'm quite unaware of the workaround Thankyou! Doobeh. Link to comment Share on other sites More sharing options...
This topic is 7829 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now