Could I get some help with Searching?

[stelf]

I've been looking on this board and can't seem to find an answer.

My problem is with searching. I'd like to show records which haven't been modified/checked on a latest build number.

The user will open a record, then check and then select the 'build checked' dropdown to the latest which is set via a valuelist, which I update every build. I wish to find out which records haven't been updated to this build.

I was thinking search as 'Open records' and-not 'build 1.4' where 'build 1.4' would be coming from a versionchecked valuelist/field setable by the search page.

But how would I do this, been puzzling me for a while.

Thanks in advance

[Vaughan]

How would you do it if the records were pieces of paper?

[stelf]

Manually check the version number against the latest version number, then put them into different piles based on that condition.

See bottom of the search atm there is a :-

<dt><input type="radio" name="-lop" value=AND>

Match all words between fields (AND)</dt>

<dt><input type="radio" name="-lop" value=OR>

Match any words between fields (OR)</dt>

This seems to work for AND or OR but doesn't work for NOT.. the condition I want to do is if record is OPEN and+not LATEST VERSION then display the records.

If I understood the scripting a bit more maybe that would allow me to do this, but currently I don't.