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?

Graham,

You're right. The table already has a primary key.

Cheers,

Robin

At 28/03/2013 04:18 AM, you wrote:
>Hi Robin
>
>You're welcome!
>
>Of course, you can also make this composite key your primary key, as Rod
>suggested, but I somehow assumed your table already had a primary key.
>
>Cheers,
>Graham
>
> >
> > From: MS_Access_Professionals@yahoogroups.com
>[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> > Sent: Wednesday, 27 March 2013 23:34
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: RE: [MS_AccessPros] How do I prevent duplication of records?
> >
> >
> > Thanks Graham,
> >
> > I had an 'inkling' that a process such as you describe was possible.
> > I will test it tomorrow.
> >
> > 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
>
>
>