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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar