Duplicates shown in lookup table

[Poul Jensen]

Hi,

I am looking up values in a related and filtered table.
The filter works OK but I am getting duplicates in the lookup browse.
Probably something wrong in the table defiinition, but I cannot locate it.
In attached doc is shown table definitions and example screendumps from desktop program (that is OK) and from NT app (that is not OK).

Any idea's most welcome.

Cheers,
/Poul

[attachment deleted by admin]

[Bruce]

what key have you set on the lookup browse as the Unique Id Key?

cheers
Bruce

[Poul Jensen]

Unique Key:  DesTstrM:KeyID

The autonumber key with a single long.

Cheers
/Poul

[Bruce]

does the table in the browse have any dependent tables attached to it?

cut & paste the VIEW declaration in the procedure here.

[Poul Jensen]

Hi Bruce,

Here is the view:

ThisView            View(DessinTypStrMem)
                      Project(DesTstrM:ID)
                      Project(DesTstrM:StrNum)
                      Project(DesTstrM:StrBeskriv)

                      Join(TV_Ud:KeyStorrelse,DesTstrM:StrBeskriv)
                      END
                    END ! of ThisView

If I OMIT this view and instead remove the join (that is correctly taken from the dct) from the view then everything works as expected !

Cheers,
/Poul

[Bruce]

ok, you're getting duplicates because you have multiple child records. If you do a join like that, and you have multiple related child records, then you get multiple records in your view.

cheers
Bruce