Steve <stevecox4444@gmail.com> wrote in
news:0b50cdbb-a13d-4f80-a120-4aecf1416668
@n1g2000prb.googlegroups.com
> I have a table which has all towns and States and postcodes
> (zipcodes) for Australia. Many duplications of town name occur as
[quoted text clipped - 10 lines]
> 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.

Signature
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **
Steve - 12 May 2008 08:26 GMT
> Steve <stevecox4...@gmail.com> wrote in
> news:0b50cdbb-a13d-4f80-a120-4aecf1416668
[quoted text clipped - 34 lines]
> PA is y I've altered my email address.
> ** Posted fromhttp://www.teranews.com**
Thanks for the assist- much appreciated