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)