TV Production Management System Database

[Daniel Mitterdorfer]

Hi All,

Does anyone know of the existance of a database out there to track the progress of a project, whilst not allowing certain fields to be populated until certain other fields are filled. The user would be warned what fields need to be filled if they tried to go past without filling them. This would happen at roughly different stages through the job.

The purpose of this database is to track the processes involved in the production of television advertisements, and to limit the producer skipping past steps involved in the production of a commercial.

Any help would be greatfully appreciated.

Thanks,

Daniel

[bruceR]

There are ways to set up relationships including auto-create relationships that use multiple fields. So you can set up a relation in which you cannot create a record unless all fields are filled in. Further, you can define some of those link fields as calc fields, where the value remains empty unless other fields have appropriate values.