Feb 13, 2011; 22:37
Trevor Jacques
[SOLVED] Duplicate/phantom child records created in portal
> Resolute Systems wrote:
>> it might be worthwhile to try switching off indexing for the fields used in the duff relationship, restarting FMPro, then then switching it back on again.
> Great idea. Unfortunately, in this case it did not work.
Actually, it did. Eventually.
I had had problems trying to export a clone and then re=EFmport, so I went back to searching for an index problem. Here's what I found:
1) After a lot of searching, I realised that the problem relationship might not be the prime relationship I was using (i.e. from order to ordered item). Uising many copies of the database file, I deleted the relationships from the ordered items file until I found the one that, when deleted, allowed proper creation of the ordered items in the portal. It turned out to be a relationship to another table that was, in this instance, unrelated to the creation of the ordered item;
2) I closed the file with the relationships, so that only my data file was open; then I took the index off the field in ordered items, switched it back on, closed the data file, and reopened both files in the usual manner. The problem persisted. Then I had the bright idea to change the link in the relationship to an unrelated field in ordered items and then switch it back to the proper, newly indexed field. This seemed to do the trick.
Hence:
1) one has to find the correct relationship and, thereby, field; noting that the relationship at fault is not necessarily the one that one is using at the time the problem was manifest;
2) one has to turn the index off and on; and
3) one might also have to change the relationship from the offending field to some other field and then back again, as well as the above steps. This was the step that eluded me the first time.
Thanks, everyone, for your help.
T.
#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>