similar function like skip

Nitesh

Is there any similar function (like skip for reports) for record?

kine

??? How you want to "skip" record???

Be more specific what you the purpose of command you are searching for...

Nitesh

There are multiple similar records, we cant apply filters.so i want to eliminate those repetative records.

kine

But where you want to skip them? In Report? In Form?

Nitesh

In Form.
suppose there are 2 similar records.we cannot filter those records even on any single field.and i want to display onle one record out of them on a form.

kine

You will need to use temp table or mark but there is no any command which will help you with that. Another thing is the whole concept, when you have such a record but you need to see just one. It means that there is wrong normalization of the tables...

bbrown

This can be done by writing custom OnFindRecord and OnNextRecord triggers.

kriki

kine wrote:

You will need to use temp table or mark but there is no any command which will help you with that. Another thing is the whole concept, when you have such a record but you need to see just one. It means that there is wrong normalization of the tables...

Avoid MARK on SQL, so better use a temptable.

Savatage

Nitesh wrote:

There are multiple similar records, we cant apply filters.so i want to eliminate those repetative records.

Curious about this.
Similar is different from same - so something is different.
"We can't apply Filters" - why?

David_Singleton

Nitesh wrote:

Is there any similar function (like skip for reports) for record?

Same as this:

http://www.mibuso.com/forum/viewtopic.php?t=26292&highlight=