JariV Posted March 1, 2005 Share Posted March 1, 2005 Hi, I have a value list (pop-up menu), whose values are pulled up from a field in another file. That field is a compilation of 2 date fields in that file (DateToText(PeriodStart)&"-"&DateToText(PeriodEnd))- ie. it is a text field. I'd like these (text) values in the pop-up menu to be sorted by PeriodStart, now they seem to be in random order. Among other things, I've tried to create a related "pop-up menu values"- field in the main file, using a relationship that sorts the related records by PeriodStart, and pull the values for the pop-up list from that field, but that doesn't seem to have any affect on how the value list is sorted. Now I'm starting to wonder whether this is at all possible...so any help with this is greatly appreciated. Jari V. Link to comment Share on other sites More sharing options...
This topic is 6605 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