Find across tables
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?