Liveware Publishing Support Forum

I am having a strange problem while trying to create a very basic report that joins two tables. When I try to set up the relationship between the tables I can^t get the Failure Action to change to anything except Terminate. If I change it to Skip or Blank it changes back to Terminate when I click OK.____If I open an existing report the relationship is fine, but if I delete and recreate the relationship in the existing report I have the same problem.____For reference, I^m using RRW Infinity 12.1.001 and trying to link the STOCK and PRICE tables in MOM on the NUMBER fields in both tables. The Relationships I^ve tried are:____scan(STOCK-->NUMBER, PRICE : NUMBER, full, terminate) __and__lookup(PRICE-->NUMBER, STOCK: NUMBER, full, terminate)____I can^t get either way to switch from terminate to either blank or skip.

What happens if you double click the relation in the Related fields dialog to bring up the older non-tabbed relationship dialog. Does it let you change it that way?____Kathleen__R&R Support

No, I^ve tried both ways. It always reverts back to "terminate".

That is indeed strange. Can you email the problem report to me so I can have a look?____Thanks.____Kathleen__livesupport@livewarepub.com

It happens with any report. Whether I try to create a new relationship in an existing report, add a relationship to an auto report, or create a new blank report and add a relationship.

Did you try a re-install>____Kathleen__R&R Support

Well, I^m still not sure what the problem was. I ended up doing a system restore to fix another issue on my system and R&R Report Writer started working fine after the restore.