Automatic record creation/relation

[DPS]

I manage an entire design studio with FM pro and have the following databases (tables):

Work Orders - invoices - timesheets - project expenses - project numbers.

All these tables inter-relate so that project numbers are value lists in all files etc.

I then have one file called "Job track". The purpose of this is to gather information from all these files together in one "report" type of file. The job track does not have any of it's own fields except the Job number to create the relationship, every other field is taken from the other tables and displayed. This is a very useful tool to oversee the status of the project, time spent, billing status etc.

My only problem is that I have to create the records in this job track so that it tracks the project and if we forget to create one for a particular project, then that project does not get tracked.

Is there any way of having this file automatically create the same amount of records as there are job numbers and fill in each of the records with one job number?

[transpower]

Use a script to go to the relevant layout and create new records as necessary.

[DPS]

OK, I can imagine doing that but it still does not make the system foolproof. If a record is created by using the top menu rather than clicking the script button that would add a record to both files, then the system has become inacurate. I was hoping that there would be a way that cannot be bypassed.

[transpower]

You don't have to click on a script button; use EventScript.

[DPS]

Ok, will try that. Thanks.