consolidate fields question

[hartmut]

Hello

I have a database of zip codes. The problem is that for a certain zip code all the hamlets and intersections are listed.

For example

for the zip code 13421 which is the city of Oneida

I get another field which claims that zip code to be the same

for Oneida Castle , Scribners corners, Five Corners, Kenwood, Merrillsville -

Anyway the main city field is called city

and the field with the alternate names is called hamlet

I would like to find a way to replace the field "hamlet" with all five field content as shown above to the new record would be

city "Oneida"

hamlet "Oneida Castle , Scribners corners, Five Corners, Kenwood, Merrillsville'

Now they are five different records under the city of oneida

I would like all the separate entries in Hamlet to all be in each Oneida record. so that all the Oneida records would show all five hamlet entries in each record as above.

I would appreciate your help very much. This is probably a script and there are over 70000 records in my database. That is why I am trying to find a way to automate this. Thanks

[Slobey]

Hi,

you can display this easily with a self join relationship and a portal. Simply create a relationship from the table with the city in it to the same table and make the key field the city.

Then on a layout with that city, place a portal showing that relationship and place the Hamlet field in it. Whatever the city on that record, all the hamlets will be displayed. check out the file I attached.

zipcode.zip