how all my records be aware of the one single record data?

[abkaplan]

I have 100 records. and my field is "dummy". On one of the records When I make that field "active" (for example), if I try to edit another record as " active" ( the same with mentioned record)the sistem should be aware of that already one of the records has been editted as "active" and never should edit another record as "active" before changing it to "passive".

That is my problem.

If you can help me I will be very happy .

Thanks in advance.

Best regards .

Abdulkadir Kaplan

[Vaughan]

Off the top of my head, they only way I can think of to achieve this is to disable all menu commands with passwords, then create buttons and scripts to perform them. The editing scripts that you create need to check for a field with active (perform a find, if no records found it's OK) before they let the actions proceed.

It's a lot of work.

Maybe something else could be done with field validation by calculation instead?

[abkaplan]

Dear Vaughan;

I solved the problem with a portal related to the same file.

I created a field : calc/name active :

(if active_passive="Active";"Active";"")

and in that portal I count the number of the "active" field. so because of the calculation there will be only a record containing "active" so the count is "1". Now I ask if the count is bigger than "0" do nothing or another thing else do that... ( because of the portal in all records show the same value it will work.)

is there any problem creating a portal related to the same file ?

Thanks

Abkaplan