AnsweredAssumed Answered

Find across tables

Question asked by mgores on Apr 15, 2014
Latest reply on Apr 16, 2014 by mgores

Title

Find across tables

Post


     I have a solution I built a while ago and it was working until this morning.

     It is a tracking solution  for our company that tracks "jobs" that  are received.  Each department has their own tracking file that is related to the Master.  In my departments file I had a script to list current jobs that performed a find on OMIT master:dateshipped >=1/1/1999. In the department file layout the dateshipped field and other common fields displayed are from the Master file.

     It was working fine until I started playing in the master file this morning and added some relation ships in the Master file back to the individual files.  I haven't gotten in this deep for a while, could the other relationship from the Master back to the Dept file have messed up that find?

Outcomes