I am trying to keep a record of who modified records but I can't figure out how to keep an on going tab of who make changes.
I created a table call modified_by and placed a portal in the table I want to keep track of the changes (Inventory) and used a lookup to get the data that it is automatically enter. But than I realized that the only way it would work is if I kept adding a new record in the modified_by portal.
Can someone point me in the right direction how I can do this.
Basically what i want is a record of who makes changes to each record.