Monitoring database usage
I would like to keep track of all the users of the database I am trying to design.
In each table, I have created fields that logs when a user creates or modifies a record, but I don't know how to tie them all together.
I tried to create a table "z_DB Maint" (with a auto entry ID number) to hold all the data. I know that it will be the parent and the other tables will be the children in the relationship. Each of the children tables have a foreign key that can be attached to the parent (z_DB Maint).
What I'm having trouble understanding is how do I get the database to automatically enter records into the parent field upon User login.
I apologize if I'm not clearly identifying my problem. I am working on the trial version of FMP9 and only had three weeks of training in FMP (or any other database), thanks to Lynda.com.
Any help would be appreciated. I'll continue to search the forum in the meantime.