Finding Open records

[Darrell]

The DB I am designing has omited records. I do not want my users to see the omited records. I have figured out how to keep my users from seeing omited records. Now here is what I am running into. I have my users sort by date then print the found set. When they make a new record it shows the found set from the previous find. I want to show all records that are not omited with a new record. How can I make this happen?

[ernst]

dbetts22 said:

I have figured out how to keep my users from seeing omitted records.

I suppose you mean you do this by using a script? If so, then re-run that script, either before creating a new record or directly after printing.

Sorry for the vague answer, but the question is quite vague as well, I'm afraid...

Ernst

[BuddySystems]

Actually, to give your users full control over the find, you really have to program the script to "add" the omit option after they "continue" the find. Something like this:

Set Error Capture (on)

Enter Find Mode (don't restore)

Pause/Resume Script

New Record Request

Set Field (put your infor for the info you want to omit here)

Omit Record

Perform Find

etc...

The bummer is that you'll have to do that for each find you have in your scripts.

[Ugo DI LUCA]

Supposing these omitted records are "marked" with a 0, you may also perform a script :

Set Error Capture (on)

Enter Find Mode (don't restore)

SetField (Mark,1)

Set Field (Your other field, the value searched)

Perform Find

If the Mark is indexed, involving a Relationship :

GTRR(Constant(1)::Mark-show)

Enter Find Mode

SetField(Your search criteria)

Perform Find