Hi I?d like to take two fields from Table A (Tickets) and have them appear and be editable in Table B (Service Reports). Our workflow (simplified) is as follows: upon receivi...
What you are looking to do is roughly possible with the use of report link fields. A report link can be used to match up and display records on another table by comparing two fields. For example in your instance since your Service Reports are related to your Tickets you can set up a report link that will display on your Service Report table to show its parent Ticket by matching the Related Ticket field in your Service reports to the Record ID in your Tickets table. That way it will only show the related parent Ticket.
Then once that field is set up you can customize your form and if you look at the options available on your report link there is a checkbox to make the report link editable on the form. This way you can set up the report link to show the fields you want to be able to edit on the ticket, and when you edit the Service Report those fields will show up in the report link as editable as well. This would allow you to change values on both tables at once.
