Hi,
How i can exclude duplicated records on the form?

Thanks.

If you use main table for these data you can eliminate them in main.table.io section.

main.table.io:
after.read:
********write your condition ***********
skip.io()

Hi,
How i can exclude duplicated records on the form?

Thanks.


Hello,

be more specific with your requirement.

what kind of form (type 1, 2, 3) ?
what kind of data (index) ?


Regards

kind of form - 2


index - table1.cmba
table1.cmba - combined field
table1.cmba={table1.val1, table1.val2}
Is displayed the field table1.val1 on the form

How i can exclude duplicated table1.val1 on the form?


_____________________________________________
main.table.io:
after.read:
********write your condition ***********
skip.io()

It works, thanks

Or alternatively, you could group by field1 in your query...

I am a little bit confused here. You are using a combined field. In my understanding these fields are a part of the index, so my question is how can you have duplicate records?

The way I understand Svetlana's requirement, he/she wants to display only one record per field1, i.e. display on form all the different values of field1, without considering the different combinations with the values of field2

If that is the case why not using the original table field instead of using the field from a combined field?????

I agree a 100%, there is no reason to use the combined field value, therefor my suggestion was also to use the specific field, as you could see in my earlier comment...

Regards,
Eli Nager

Eli,

The golden rule "KISS" would be appropiate for this thread.

Marioth,

I am not aware of the golden rule "KISS"; could you please elaborate....?

Eli

Marioth,

I am not aware of the golden rule "KISS"; could you please elaborate....?

Eli



Hello Eli,

Keep It Small and Simple !

Regards

That's all?? And you meanwhile got me all turned on and excited... ;)