Highlight record when new record added to related table
I am not great at writing original code and I can't find this anywhere.
I am trying to automatically highlight a record on a table when a new record is added to a related table.
In this case I have a "Claims" table and "Request" table. The relationship is many requests to one claim. I would like the claim to be highlighted when a request is added. The requests are coming from a separate application that is open to all on the internet. I have an action setup that when a new request is entered, it copies that request to the request table in my closed application and is then linked through the table to table relationship to the corresponding claim.
So in summary - someone on the internet enters a request. The request is copied into a table in a different application and is then linked to a claim. When that happens, I would like the claim to highlight red to alert me that a request has been added.
I hope this makes sense. Any help is greatly appreciated.
I am trying to automatically highlight a record on a table when a new record is added to a related table.
In this case I have a "Claims" table and "Request" table. The relationship is many requests to one claim. I would like the claim to be highlighted when a request is added. The requests are coming from a separate application that is open to all on the internet. I have an action setup that when a new request is entered, it copies that request to the request table in my closed application and is then linked through the table to table relationship to the corresponding claim.
So in summary - someone on the internet enters a request. The request is copied into a table in a different application and is then linked to a claim. When that happens, I would like the claim to highlight red to alert me that a request has been added.
I hope this makes sense. Any help is greatly appreciated.
