Is it possible to make a combination of 3 fields be unique? I know you can
have the ID (autonumber) be unique or have a field set to be indexed and not
allow duplicates but I need to use 3 fields.

My scenario is a table (tblPeople) with Fname, Lname and postcode. I do not
want any duplicate people in my tblPeople. They all have multiple linked
records in tblProjects. The problem is that someone doing data entry keeps
creating duplicate people entries when they exist already. Can I set these 3
to be unique together? Not as individual uniques.

Would it be easier to make a field in the tblPeople that is a combination of
Fname Lname Postcode and that be unique? Then on the form it would use some
code to make the combination entered into that field. I could run a query to
make the 3000+ records have that combination field so its all up to date.

What is my best approach? Any help or thoughts are appreciated. Many thaks.

JBowler