K
Kass
I have a calculated form entry that I use for a Personal
ID. The form entry for the PID is calculated by UCASE
([LastName] & [FirstName]) which gives me a result
like "COOLJOE". I then use this to avoid record
duplication (there can be no two people with the same
name). I did this in one database I made and now I can't
figure out how I made it work. I set the corresponding
table PID column index to "Duplicates NO". Of course
since the form is calculated, the table doesn't pick it
up. I made a query that is related to the table through
the Primary Key ID (which is auto numbered) and redid the
calculation for PID in the query, but it still doesn't
wkeep me from duplicating a name in the form. Can you
help?
Also, is there a better way to stop record duplication in
a form that is using a calculated field. (I want to use
First and Last Names so you can't enter a person twice.
Thanks!
Kass
ID. The form entry for the PID is calculated by UCASE
([LastName] & [FirstName]) which gives me a result
like "COOLJOE". I then use this to avoid record
duplication (there can be no two people with the same
name). I did this in one database I made and now I can't
figure out how I made it work. I set the corresponding
table PID column index to "Duplicates NO". Of course
since the form is calculated, the table doesn't pick it
up. I made a query that is related to the table through
the Primary Key ID (which is auto numbered) and redid the
calculation for PID in the query, but it still doesn't
wkeep me from duplicating a name in the form. Can you
help?
Also, is there a better way to stop record duplication in
a form that is using a calculated field. (I want to use
First and Last Names so you can't enter a person twice.
Thanks!
Kass