AnsweredAssumed Answered

Postcode lookup using value list

Question asked by symbister on Oct 11, 2013
Latest reply on Oct 21, 2013 by philmodjunk


Postcode lookup using value list



     I've recently setup a postcode lookup, using a table of about 15,000 records = 'Postcodes' (three fields: code, state, suburb) and using a TO of this table 'Postcodes for Home Lookup'

     The home_suburb field on the layout uses a Value List 'home_suburb' set up as per screen shot, but only the first of each suburb name is being displayed. For example there are three Rivertons, but only the lowest PC# displays.

     what am i doing wrong? apologies for the scruffy screen shot

     (the State and Postcode fields are then auto-enter lookup fields from the same TO)