Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form "Personnel" with a subform named "Qualified". The table linked
to the subform can have multiple duplicate records so I can not index it to
not allow duplicates. But, I need to figure out a way to not alow duplicate
records in the task field of the subform so a calculation will work properly.
Is the an easy way to accomplish this with some code? My fields are below:

[Autonumber](Key)
[SSN] (F-Key)
[Task] (F-key) ***cannot contain duplicate values on the form only but must
be allowed in the table****
 
well, if you cannot have duplicate values in the tasks assigned to a
specific SSN, then suggest you create a multi-field unique index in the
*table*, using both the SSN and Task fields. that will allow duplicate
values in either field by itself, but not duplicate values in the
*combination* of both fields.

hth
 
I will try that thanks

tina said:
well, if you cannot have duplicate values in the tasks assigned to a
specific SSN, then suggest you create a multi-field unique index in the
*table*, using both the SSN and Task fields. that will allow duplicate
values in either field by itself, but not duplicate values in the
*combination* of both fields.

hth


Darrin said:
I have a form "Personnel" with a subform named "Qualified". The table linked
to the subform can have multiple duplicate records so I can not index it to
not allow duplicates. But, I need to figure out a way to not alow duplicate
records in the task field of the subform so a calculation will work properly.
Is the an easy way to accomplish this with some code? My fields are below:

[Autonumber](Key)
[SSN] (F-Key)
[Task] (F-key) ***cannot contain duplicate values on the form only but must
be allowed in the table****
Click to expand...
Click to expand...
 
you're welcome :)


Darrin said:
I will try that thanks

tina said:
well, if you cannot have duplicate values in the tasks assigned to a
specific SSN, then suggest you create a multi-field unique index in the
*table*, using both the SSN and Task fields. that will allow duplicate
values in either field by itself, but not duplicate values in the
*combination* of both fields.

hth


Darrin said:
I have a form "Personnel" with a subform named "Qualified". The table linked
to the subform can have multiple duplicate records so I can not index
Click to expand...
it
to
not allow duplicates. But, I need to figure out a way to not alow duplicate
records in the task field of the subform so a calculation will work properly.
Is the an easy way to accomplish this with some code? My fields are below:

[Autonumber](Key)
[SSN] (F-Key)
[Task] (F-key) ***cannot contain duplicate values on the form only but must
be allowed in the table****
Click to expand...
Click to expand...
Click to expand...
 
Back
Top