Jump to content

consolidate fields question


This topic is 5728 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5728 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

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.