duplicate this!

[michael]

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?

[Allen Browne]

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
existing table.

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" <nn@yy.com> wrote in message
news:083401c34b4b$70748260$a101280a@phx.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?

[John Vinson]

On Tue, 15 Jul 2003 20:36:27 -0700, "michael" <nn@yy.com> wrote:

>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.

In addition to Allen's comments, consider the fact that names ARE NOT
UNIQUE. I used to work with Dr. Lawrence David Wise, and his colleague
Dr. Lawrence David Wise. Larry was tall, blond and outgoing; L. David
was stocky, dark and taciturn. You may be setting yourself up for a
problem!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[michael]

Great idea however I need the the form to beeb the person
doing the intke to be told when they enter BOB Smith into
the form that he already exsists. how can I do that - is
ther some way for the form to check the all the feilds or
the new table table that that name already exsists?

>-----Original Message-----
>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

>existing table.
>
>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" <nn@yy.com> wrote in message
>news:083401c34b4b$70748260$a101280a@phx.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?

>
>
>.
>