Jump to content

Auto enter to line items when record is created or modified


kmninbox
 Share

This topic is 4328 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello friends,

I have a customerTable with fields customerID and currentSalesRep. I have another customerNotesTable that acts as a line items table for keeping track of notes related to the customerID. I have match fields being customerID. In a form layout on the customerTable I have a portal to the customerNotesTable line items with fields NoteField, CreatedBy, & DateCreated

I am trying to find a way to have a new note automatically created (new record on the customerNotesTable) when modification is done to the customer record in any field. In this example, if I change the currentSalesRep for a customer in the customerTable from "John Deer" to "Jane Doe," I would like for a new note/line item record to be automatically created in the customerNotesTable, with the NoteField containing the details of the change, ie something like "currentSalesRep changed from John Deer to Jane Doe" and then CreatedBy would be auto enter account name, and DateCreated would be auto enter date.

Ideally, I would want any change to any field to automatically create a new note saying which field was changed from what value to what value, who did it, and when.

Does this sound possible?

TIA

Link to comment
Share on other sites

This topic is 4328 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.