I’m fairly new in working on Generic Inquiries, and would like some guidance on how best proceed. I’m attempting to pull in attribute values from inventory item on a quote. My existing table is below:
All of the Join Types are set to Inner:
When I view the inquiry, it is essential replicating the lines:
The quote itself only has 4 items:
Best answer by bwhite49
To prevent duplication, you will likely need to add each attribute one at a time and you only need to add CSAttributeDetail for combo box type attrbutes. CSAnswers already has all the data you need for text data. So if you need to add 5 attributes from an item into your report, you are going to need to add CSAnswers 5 times into your data relations. One relation for each attribute. I don’t think you need CSAttribute involved.
To prevent duplication, you will likely need to add each attribute one at a time and you only need to add CSAttributeDetail for combo box type attrbutes. CSAnswers already has all the data you need for text data. So if you need to add 5 attributes from an item into your report, you are going to need to add CSAnswers 5 times into your data relations. One relation for each attribute. I don’t think you need CSAttribute involved.