I add a record to table via a script ... that part works Ok ... but when I add the record it gets added to an existing found set.

I want to have it as the only record in the found set. In other words I want to discard the entire found set before I do the new record request. I have been unable to find a straightforward way to do this. Is there one?

Depends on what you call straightforward but inserting the following after your New Record/Request step will do what you want

Show All Records

Omit Record

Show Omitted only

HTH,

Peter

If i understand:

Show All Records

New Record request

Such?

And if you want to see in found set only this record:

Omit Record

Show omited.

I am sorry! When i was printng my post last answer was not here.

Hey, don't worry, at least she got a consistent answer !

Peter

To start with no found set in a multi-user system,

Show All Records

Show Omitted Only

Loop

Exit Loop If [not Get(FoundCount)]

Omit Record

End Loop

If not multi-user, the loop is superfluous.

To isolate a new record in a multi-user system,

New Record/Request

Show All Records

Omit Record

Show Omitted Only

Loop

Exit Loop If [Get(FoundCount) = 1]

Go to Record/Request/Page [Last]

Omit Record

End Loop

Or create a simple self-relationship based on the serial and use

New Record/Request

Commit Records/Requests [skip data entry validation; No dialog]

Go to Related Record [show only related; "self-relationship"; ]

OK, you have already explained the first part before. But the second part? How is it possible for a user who has just intitated New Record to end up on another record?

It is not possible. Read the original post again. It isolates the new record, regardless of how many records are in the current found set. But you know this already; maybe you just haven't had your coffee yet? :o

Touché, and well deserved!