elgordon

Wow, blindingly simple, thanks -Queue- my headache has magically disappeared.

Help, I know there must be a simple solution. I have two DB's (JobBook and timetracker) with a one to many relationship based on a Job# field. I am trying perform a find on the related field Job# using the active record from JobBook. I have tried using both a Copy and Paste scenario and a self join scenario.. Scenario 1 (just a description, not exact syntax) in JobBook - Copy Job# from active JobBook record - Run external script (timetracker, Find) in timetracker, Find script - Paste into a global field (Job# copy) - Enter Find mode and Set Field (Job#, Job# copy) - Perform Find Scenario 2 (also just a description, not exact syntax) in JobBook - Run external script (timetracker, selfjoin) in timetracker, selfjoin script based on selfjoin relationship using Job# as the key - Show All Records - Go To Related Record (show, "selfjoin") Both work on my machine locally but fail when I try and use the same technique on networked files. I've tried everything I can think of and think I'm going a bit crazy. When it runs on the networked files, it finds the wrong info...the self join finds completely unrelated records (the same one over and over actually)...any words of wisdom?? Addition to the original post - I've posted examples of the files. Now, they're not working locally either... I thought about it a bit and what I'm really trying to arrive at is a summary of the timed sessions shown in the portal. Although I'm new enough to this that I haven't figured out how to do that either. Thanks for your advice. FileMaker Version: 6 Platform: Mac OS X Jaguar timetracker_test.zip