Table Box Hides Duplicate Rows

[#1]

Hello

Why do table boxes not show dupliate records? I have an application with valid duplicate records and for completeness I really need to show them all in the table. See the example application, attached.

Any ideas?

Thanks.

[sparur · Accepted solution]

Hello James.

TableBox works as ListBox, so it shows only unique values.

If you want to see all rows, you should add in script new field (linenum for example).

Load

...

rowno() as Linenum

FROM ....

and then use it new field in your tablebox.

[sparur]

see in my example