relational index (AREV Specific)
At 17 MAR 2003 05:31:29PM Mark S Gollehon wrote:
Hello ,
I have created a relational index based on the primary key Vendor Number and a multi-valued column, customer no. The relational index is stored in a file called vendor_rebate_xref. So basically, I can use the Customer No to get access to a list of vendor numbers. The problem is that I get duplicate vendor numbers stored in the relational file since there can be duplicates in the column. Is there a way to prevent duplicates within the relation file. For example, when I edit the relational file for customer APPF43 I want to see the keys 5165 5167 1568 and not 5165 5165 5165 5167 5167 5168 5168.
Thanks Mark
At 17 MAR 2003 07:11PM Richard Hunt wrote:
Create a cross-reference index instead. Create a symbolic that "uniques" the vendor numbers within the multivalued data field. Use the symbolic as the index.
At 18 MAR 2003 09:10AM Don Miller - C3 Inc. wrote:
But beware of the problem of indexing symbolics when the data changes. It's correct at first, but if the associated record changes the Vendor#, the old one WON'T get removed and the new one MAY not be added either. If you search the forum, there are a couple of items that might be important to you .. Sprezz posted a way to fix this on their site.
Don M.