Check a record

[Raybaudi]

Hi all

It's possible to check a field ( formatted as check box ) in a record in list view so that, if i'll check the same field in another record, that first field re-evaluates to uncheck itself ?

That is easy with a script, but with AutoEnter calc and relationship ?

[Søren Dyhr]

There is something wrong with the metaphors here, the behaviour is the one belonging to a radio button, not a checkbox!

--sd

[comment]

A stored calculation will NOT re-evaluate upon modification of a related record.

[Raybaudi]

...the behaviour is the one belonging to a radio button, not a checkbox!

Yes, Soren, the same behaviour belonging to a radio button.

A stored calculation will NOT re-evaluate upon modification of a related record.

So, do you think that it's impossible ? ( I'm quite of your opinion )

[comment]

It is impossible the way you have decribed it.

But the question is why should it be that way? After all, the field is supposed to hold only ONE piece of information for ANY number of records in the table. Shouldn't such field be a global field, holding the ID of the selected record? Then, using a "private" value list for each record, and an auto-entered calculation, you can take care of the display.

PrivateVL.fp7.zip

[Raybaudi]

Perfect !

I had lost my hope...

Many thanks, comment.

[Raybaudi]

Hi comment

your simple calc:

GetAsNumber ( RightValues ( gSelectedID ; 1 ) )

is a real "brainwave"