how to restrict duplicated record

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

An applicant (table A) has a number of applications (table b)(sub-form)

Like this,

Peter - application-1
application-2
Mary - application-1
application-2
application-3

how can i restrict users to input another application-1 to Peter

i know there is an option to restrict duplicated record in Table, but it
applies to whole table, how i can only apply records related to applicant -
Peter.

Thank you very much.
 
i know there is an option to restrict duplicated record in Table, but it
applies to whole table, how i can only apply records related to applicant -
Peter.
Click to expand...

You can create a unique Index on *UP TO TEN* fields. Use the Indexes
tool in table design; type the name of an index (OnePerPerson perhaps)
in the left column, and specify the two (or more) fieldnames in the
right column. Check the checkbox for Unique Index.
 
Thanks John

What are the left column and the right column.

For the moment, i can just make it unique in a table.

Thanks a lot.

Tony
 
Thanks John

What are the left column and the right column.
Click to expand...

When you click the Indexes icon, or select View... Indexes from the
menu, a little box pops up with two columns. The left column is for
the name of an index (which should be unique within the table but can
be anything), the right column is for the field or fields in that
index.
 
Thanks John

I got it.

Tony


John Vinson said:
When you click the Indexes icon, or select View... Indexes from the
menu, a little box pops up with two columns. The left column is for
the name of an index (which should be unique within the table but can
be anything), the right column is for the field or fields in that
index.
Click to expand...
 
Back
Top