NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Poul Jensen on August 29, 2013, 01:57:33 PM

Title: Duplicates shown in lookup table
Post by: Poul Jensen on August 29, 2013, 01:57:33 PM

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]

Title: Re: Duplicates shown in lookup table
Post by: Bruce on August 29, 2013, 10:52:25 PM

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

cheers
Bruce

Title: Re: Duplicates shown in lookup table
Post by: Poul Jensen on August 30, 2013, 12:23:18 AM

Unique Key:  DesTstrM:KeyID

The autonumber key with a single long.

Cheers
/Poul

Title: Re: Duplicates shown in lookup table
Post by: Bruce on September 02, 2013, 03:48:54 AM

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

cut & paste the VIEW declaration in the procedure here.

Title: Re: Duplicates shown in lookup table
Post by: Poul Jensen on September 02, 2013, 06:26:23 AM

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

Title: Re: Duplicates shown in lookup table
Post by: Bruce on September 02, 2013, 09:00:17 AM

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