ACCESS FEED: RE: [MS_AccessPros] How do I prevent duplication of records?

Rabu, 27 Maret 2013

RE: [MS_AccessPros] How do I prevent duplication of records?

G'Day Graham.

I have run a "Find Duplicates" query on the table to prove that all
entries are unique.

I have built the index on the three fields as you described.

An error message advises that " .. duplicates would be established .. .,."

Now I am really confused !!!!

Cheers,

Robin

At 27/03/2013 08:40 PM, you wrote:
>Hi Robin
>
>You need to create a composite index comprising the three fields.
>
>In table design view, click the Indexes button to show the floating Indexes
>window.
>
>In the left column (Index Name) of the first blank row, type a name, such
>"Member_Year_Post", and in the second column (Field Name) select MemberID.
>
>In the properties below, change Unique to "Yes".
>
>In the next two rows, select YearID and PostID for Field Name (leave Index
>Name blank).
>
>You will now have an index which will disallow two records with the same
>combination of these three fields.
>
>Cheers,
>Graham
>
> > To: MS_Access_Professionals@yahoogroups.com
> > From: robinski@mymail.net.au
> > Date: Wed, 27 Mar 2013 11:52:53 +1100
> > Subject: [MS_AccessPros] How do I prevent duplication of records?
> >
> > I have a table which includes the fields: "MemberID" and "YearID" and
>"PostID".
> >
> > How do I prevent duplication of the combination of the three fields
> > berceuse data entry is not by Access form?
> >
> > Data entry is on a remote server by ASP pages.
> >
> > Many Thanks.
> >
> > Robin Chapple
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>