LinkedIn
Twitter
I have an app with three tables: Employees, Service Records, and Systems.
The Service Record table contains records from all Systems, and is related to the Systems table with a System ID column in each table. A new service record row will be created when data is entered in the service record form by the Service Technician in the field. In the form, there is an Enum dropdown to select "System Status" at the time of service, with several options, including "Winterized", "Running", and so on. My goal is to have the "System Status" column in the Systems table row for that system update (automatically, upon save of the new Service Record) to reflect the System Status column in Service Records table for the newly created row (record).
Example: Service Technician selects "Winterized" in the form and saves. Row in Service Records is "Winterized", and row in Systems updated to "Winterized" also.
Note: I have used the "Timestamp" column in Service Records as the Key so that I can take advantage of MAXROW functions in looking up previous rows for individual systems. The Systems table uses the "System ID" column as Key.
I have attempted many solutions for this (including the use of Actions and Bots), but none have worked so far.
I am still new at this, and so there is a lot I don't understand. It is also another of many hats I wear as Operations Manager, and so I have a limited budget and background in any IT or coding settings.
I have included several screenshots. I hope these will help.
Thanks for any help you can offer.
