how to restrict duplicated record

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

 

[StCyrM]

In your table design, simply do not allow duplicates in the index proprety

 

[John Vinson]

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.

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.

 

[tony wong]

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

 

[John Vinson]

Thanks John

What are the left column and the right column.

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.

 

[tony wong]

Thanks John

I got it.

Tony

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.