Jump to content

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


This topic is 8513 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

This topic is 8513 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.