I have a layout with a couple of portals for a quoting application. The portals both allow creation/deletion of records in their respective join table.
I'm capturing the creation date and creation account name, as well as the modification account name and modification timestamp.
Modification account name and modification timestamp both work as expected, when the row the main database is changed, it captures what I'm expecting.
My problem is that when an line is added, removed, or changed in one of the join tables, I need to capture a new modification timestamp and modification account name in the primary database.
I'm sure this will involve some scripting, but I'm not sure how to tackle it.