Help - Need to Setup Audit Database for Warner Bros.
I am setting up an audit Database for Warner Bros. I am new to this program and need some help. I set up a "master" database that will house all of the information for every Department (i.e. feature, television, and animation). Now, I need to setup a database (or table if that would be better I am not sure) to seperate Television and Feature. I would like Feature to only view feature and televsion to only view television and both of them to feed into the "master." I know how to setup the different databses, but I am having trouble with them creating records for one another. I also want a new record created in feature to show up as a feature record in the "master."
Let me know if you have any ideas or if I did not explain this clearly. Thanks for your help!