Newbies Hew Posted January 26, 2005 Newbies Share Posted January 26, 2005 There must be a simple solution - but I can't find it. When a user enters a ctiy name I would like to add the postcode and state at the press of a button. The postcodes come from a value list based on all cities and postcodes already entered. I would like to do this by using the vlaue lists and there seems to be all the functions except one. The value list for postcode and town can be put into two global fields with 'ValueListItems ( Get ( FileName ) ; "Postcodes")' and ValueListItems ( Get ( FileName ) ; "City"). I would like to be able to find the value number of the city so that the script could pull the postcode from the coresponding value postion in Postcodes with 'MiddleValues ( Postcodes ; position of city value ; 1 ), something like "ValuePosition( City ; in value list called city)" would be wonderful! A solution with a self join woul work but I just wondered if this wonderful new Value function was fully implemented? Link to comment Share on other sites More sharing options...
This topic is 6637 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