view

[Former Member]

hi,

i have created database view

but it showing duplicate entries in it.

how to solve this problem ?

[Former Member]

Probably you can select the data from the tables based on primary key. Write the joins on the basis of primary keys.

Supriya.

[Former Member]

Make sure that all the primary keys of the data base table should be in your view also.

[Former Member]

Hi,

How any tables have you used? Please specify the keys in the Join fields section and it will avoid duplicates.

Reward if useful.

Thanks,

Anita