Server Script Using Two Files
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?