Relational Index problem (AREV Specific)
At 29 OCT 1997 10:19:41AM Dave Berkovsky wrote:
I have defined a relational index but it is not working properly. If I have more then one record in detail table that relates to one record in master table, what happens is that first key is updated correctly and then instead of updating multivalue field in master table it created a new row in a master table. Does anyone knows what is my problem ???
Dave Berkovsky
At 29 OCT 1997 05:19PM Aaron Kaplan wrote:
It almost sounds like you set the index up backwards. Each field in the MV of the detail would create a seperate key in the master.
At 01 NOV 1997 11:15PM Larry Wilson wrote:
Dave,
1) make sure the MASTER FLAG is set for the field being indexed and for the target field.2) make sure the length and justification for BOTH fields are set correctly and for a length AT LEAST as long as the longest ID (key) you might be indexing.3) make sure you have the sort correct. AL for text and AR for numeric; any of the others may be used for either numeric or text IDs.If you have to change anything, be sure to completely REMOVE the index, make the changes (such as the MASTER FLAG) and then re-install the index.I hope this helps.
Larry Wilson
TARDIS Systems, Inc.
303-432-8630