Having two fields with no duplicated data

[aria]

Hi all,

We have a table called FMRI

There are two fields that we would like to set as semi unique value:

1.Subj_num

2. FM_subj_num

For both fields I setup Validation “Not empty”

What we like to do is, prevent users from creating duplicated record with the following fields:

subj_num and FM_Subj_num .

Such as:

In ideal situation we would like it such as:

Record 1: subj_num = 2 and FM_SUBJ_NUM = 3

Record 2: Subj_num = 10 and FM_subj_num = 3

But if users create two records like this then inform users that there is a duplicated subj_num and FM_subj_num already exist in database:

Record 1: subj_num = 10 FM_SUBJ_NUM = 3

Record 2: Subj_num = 10 FM_subj_num = 3

Please advise,

Thanks in advance,

Abrahim

[comment]

You could define a third field of type Text and set it to auto-enter (replacing existing value) a calculated value =

Subj_num & "|" & FM_subj_num

Set the field's validation to Unique, Validate always.

[aria]

Hi there,

I did set new field called GFM_Num type Text and set it to auto-enter (replacing existing value) a calculated value =

Subj_num & "|" & FM_subj_num

Set the field's validation to Unique, Validate always.

Now when I go enter some data in Subj_num field and leave the feild, I get the following error:

“Subj_Num” is defined to contain existing value only. You must enter one of the existing values.

Any idea?

Thanks,

A

[aria]

Never mind.

The existing value was selected so I just deselect it.

All is working well!!!

Thanks,

A