Add towns

[Steve]

I have a table which has all towns and States and postcodes (zipcodes)
for Australia. Many duplications of town name occur as there can be
more than one town in different states or even same town name in one
state but different postcode.

No problem , the data is already there.

However I would like to be able to add non Australian Names but ensure
there is no duplication on adding. I cant use Town name as Indexed ,
no duplicates (because of duplication mentioned above) and need a
method to have a combination of State, Town and Postcode or Twon and
Postcode not allow for duplicates.
Any help appreciated
Steve

[Bob Quintal]

Re: Add towns

Steve <stevecox4444@g mail.comwrote in
news:0b50cdbb-a13d-4f80-a120-4aecf1416668
@n1g2000prb.goo glegroups.com
:

I have a table which has all towns and States and postcodes
(zipcodes) for Australia. Many duplications of town name occur as
there can be more than one town in different states or even same
town name in one state but different postcode.
>
No problem , the data is already there.
>
However I would like to be able to add non Australian Names but
ensure there is no duplication on adding. I cant use Town name as
Indexed , no duplicates (because of duplication mentioned above)
and need a method to have a combination of State, Town and
Postcode or Twon and Postcode not allow for duplicates.
Any help appreciated
Steve
>

so open the table in design mode, click on the record selector for
town, Control Click on the record selector for state, control-click
on the record selector for postcode, then click on the key icon in
the toolbar. save your changes.

That will either create a new primary key with the three fields, or
tell you that there are duplicates.

It's that simple.

Now click on the indexes icon in the toolbar and see how Access has
entered the data, so you can additional compound indexes using the
indexes dialog.


--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

[Steve]

Re: Add towns

On May 11, 9:36 pm, Bob Quintal <rquin...@sPAmp atico.cawrote:

Steve <stevecox4...@g mail.comwrote in
news:0b50cdbb-a13d-4f80-a120-4aecf1416668
@n1g2000prb.goo glegroups.com
:
>

I have a table which has all towns and States and postcodes
(zipcodes) for Australia.  Many duplications of town name occur as
there can be more than one town in different states or even same
town name in one state but different postcode.

>

No problem , the data is already there.

>

However I would like to be able to add non Australian Names but
ensure there is no duplication on adding.  I cant use Town name as
Indexed , no duplicates (because of duplication mentioned above)
and need a method to have a combination of State, Town and
Postcode or Twon and Postcode not allow for duplicates.
Any help appreciated
Steve

>
so open the table in design mode, click on the record selector for
town, Control Click on the record selector for state, control-click
on the record selector for postcode, then click on the key icon in
the toolbar. save your changes.
>
That will either create a new primary key with the three fields, or
tell you that there are duplicates.
>
It's that simple.
>
Now click on the indexes icon in the toolbar and see how Access has
entered the data, so you can additional compound indexes using the
indexes dialog.
>
--
Bob Quintal
>
PA is y I've altered my email address.
** Posted fromhttp://www.teranews.co m**

Thanks for the assist- much appreciated