duplicate rows in View

[Former Member]

hi friends

i hav created a view. it joins 4 tables and i want to display 5 fields.

they are:

mara-matnr

mara-mtart

marc-werks

mard-lgort

makt-maktx.

the prblem is each line item is duplicating in the output.

how i can avoid this?

[Former Member]

hello,

here's the code.

Function duplicheck()

Dim dr As DataRow

Dim bugid As String

bugid = Nothing

For Each dr In ds1.Tables("form_data").Rows

If dr.Item("bug_id") = bugid Then

ds1.Tables("form_data").Rows.Remove(dr)

bugid = dr.Item("bug_id")

End If

Next

End Function

Reward if Useful.

Regards

[Former Member]

Hi aparna

i'm using View. where i can write the code?

[Former Member]

Hi!

It can be becaue MAKT has a SPRAS field in the key. If it is maintained by more languages, it will have more entries.

The other possible error, if you forget the MANDT field from the JOIN and you have more clients, it could duplicate the entires also.

Regards

Tamá

[Former Member]

Hi,

check this link..

Hope this would hep you.

Regards

Narin