duplicate this!

  • Thread starter Thread starter michael
  • Start date Start date
M

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?
 
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).
 
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.
Click to expand...

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!
 
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?
 
Back
Top