I'm having a recurring problem with virtual joins. I have a series of tables that are "daisy-chained" together by virtual join. That is, Table 1 link references Table 2, Table 2 link references Table 3, Table 3 link references Table 4, and so on. My daisy-chain is six tables long in all. (The set of tables represents a 6-level hierarchy of one-to-many entities…).
This works fine mostly, but the link references tend to get scrambled when I save the tables. Often I notice that a perfectly valid Reference Table value gets changed to "myEnclosingFolder/(A Document Being Saved by JMP)/myTargetTable.jmp". Of course, this is just a temporary folder that JMP deletes after the save, yet the Link Reference property doesn't synchronize. Sometimes I wish I could just tell JMP to stop trying to be so helpful and just let me hard-wire in the Reference Table path.
Is there a way I can do this better?
