AnsweredAssumed Answered

Adding to matched relationship table w/o overwriting?

Question asked by 34South on Sep 6, 2018
Latest reply on Sep 6, 2018 by philmodjunk

I have a relationship which allows creation of new records in the target table which is based on information contained in the source table, for example, patient folder AND procedure date but, since I do not want to overwrite existing records in the target table which match these matching criteria but add to them, also includes a third match which is simply based on an unlimited random number. However, what I have noticed is that this adds a significant delay to a script which calls on that relationship. I presume this is due to indexing/sorting of the target table since, if I exclude indexing of the corresponding number field in that table, the relationship does not work. Should I perhaps truncate my random number to fewer digits or use an integer and rather get the maximum for a folder/date relationship and append that by 1 and then use the more complex relationship? Perhaps there is a much simpler method?

Outcomes