There is a very easy solution.
Instead of using repeating fields within your table, create a related table.
The new table with have a one-to-many relationship with the first table,
i.e. there can be many adults in the new table related to one record in the
Since all the adults are not in one field, you can place a unique index on
that field ("Yes: No Duplicates" in the lower pane in table design).
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")
"michael" <nnyy.com> wrote in message
news:083401c34b4b$70748260$a101280aphx.gbl...> I have a form with three fields to enter a name
> (Adult1,adult2 etc).
> I can make no duplicates in one of the fields but I need
> to make sure a name isn't entered twice regardless of
> adult1,adult2 etc.
> Basically how do i Index all three at once?