Steve <stevecox4444@[EMAIL PROTECTED]
> wrote in
news:0b50cdbb-a13d-4f80-a120-4aecf1416668
@[EMAIL PROTECTED]
> 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
**
|
