On May 11, 9:36=A0pm, Bob Quintal <rquin...@[EMAIL PROTECTED]
> wrote:
> Steve <stevecox4...@[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. =A0Many 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. =A0I 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.com**
Thanks for the assist- much appreciated
|
