AnsweredAssumed Answered

Server Script Using Two Files

Question asked by psuchad on Mar 25, 2010
Latest reply on Mar 29, 2010 by TSGal

Title

Server Script Using Two Files

Your post

I am trying to run an automated server script that spans across two files.  Here is the setup:

 

In File1 there is a Staff table that lists all demographic information for employees.  In File2 there is a table for time sheets.  The two tables/files are linked by staff_id.  I want to run a script that automatically emails staff who have overdue time sheets.  This works when the email address is stored in the time sheet table, but the real location is in the staff table in File1.

 

Doing some Googling I have seen that when a server runs a script it cannot go between files even though there are relationships between the two.  Is there a way to directly reference a related field so that the server can grab data from another file?

Outcomes