repeated records

[alpertunga65]

Hi everyone


I have two forms, Frm_ FREQUENCY_LIST (it’s table is FREQUENCY_LIST) and Frm_FREQUENCY_PRO (it’s table is FREQUENCY_PRO.)

Frm_FREQUENCY_LIST is for listing all frequencies in a band. Frm_FREQUENCY_PRO is to assing frequency for a radionet from FREQUENCY_LIST table.

Key fields of Frm_FREQUENCY_PRO are; FreID, CVRID and VERYERID which are aouto numbers. FreID is auto number for FREQUENCY field, CVRID is auto number of radionet. VERYERID is auto number of the location where the radionet works.

Key field of Frm_FREQUENCY_LIST is FreID (auto number of FREQUENCY field).

What I want to do is;

To assing a proper frequency to a radionet depending on FreID, CVRID and VERYERID.
My criterias are;

• To assing a frequency to a radionet at a location only one time. It must be impossible to assing the same frequency to any net (not only the same one but also a different one) at the same location. But it must be possible to assing a second frequency to the same radionet at the same location.

• It must be possible to assing a frequency which was used at a location for another location.

• If I assign such a repeated frequency, I want to have a warning msgbox and UNDO…

I tried it with DCount, but I couldn’t.

I need Help…