[Hx] two quetions

[ROGER BILLCLIFFE]

Helix 7.0.4

1 I have a post that transfers data from records in one collection to create new records in a second relation. Occasionally an incomplete second, duplicate, record is created. There seems to be no consistency or difference between posts which are entered twice and those which have correct single record entry. Unfortunately, the duplicates have by UK Revenue law to stay in the destination relation and cannot be deleted. I usually add DUPLICATE ENTRY to a text field when I have identified the duplicate but cannot work out how to search for records which DO NOT contain that text string. It must be easy….but not obvious

2 Why is this happening? There are some similarities between the kind of records that get duplicated but nothing consistent that identify an error or discrepancy in either the source record or the post

Any help gratefully received

Roger




=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

You received this message because you are subscribed to the mailing list <Hel...@gibhenry.com>.
To unsubscribe, send an email <Helix...@gibhenry.com>; to switch to DIGEST mode, send an email to <Helix-L...@gibhenry.com>; to contact a human being, send an email to <Helix-L...@gibhenry.com>.
Google archive since 20 August 2006: http://groups.google.com/group/helix-l.
Basic archive since March 2017: https://gibhenry.com:9100/Lists/Helix-L/List.html

[Lenny Eiger]

Roger,

What is the link between these relations (in the post, target and source)? Is the target indexed?

Lenny