Quote

[krishnapriya]

In Product, I have 2 products named->

1. Afrobat Rider belongs to category A
2. Afrobat Rider belongs to category B

In Quotes, on clicking product name, the dialog displays these 2 Afrobat Rider.

I need to display Afrobat Rider only once. No duplicates. Because I have another field in quote to select category.

And product dialog displays only name. So duplicates names should not be there.

How can I achieve this?

Please help.

[tanya]

Add a filter for products by selected category, like in Opportunity -> it shows only contacts related to selected account.

[krishnapriya]

Hi Tanya,

I need to select category after selecting the product.

Like if I select Afrobat Rider as the product name, then next field is category dropdown field, which will load category A and B.

[tanya]

for this you need to have one product with several categories. you need many-to-many relationship instead of current one-to-many

[krishnapriya]

Afrobat Rider of category A is different from Category B. My Product is saved like this.

1. Name: Afrobat Rider
Category : A
Price:1000
2. Name: Afrobat Rider
Category: B
Price:2000


So I have Afrobat Rider listed 2 times in Product/list View. But in Quote I need to see only one name.

Can I use mysql query like 'select distinct name from product'something like this to get the collection.

Please help.