I have a need to setup a history of interactions with a job file. I currently have it working fine where when someone adds a note a new history entry is created in a History table, when someone enters a new order for the job a history record is created in the same History table.
The problem is that the records that are being created are not connecting to the job directly. So I create a view with a table to show all history for that job and I can't. All I can do is individual tables showing "records further connected" to the job for each history type (i.e. order or note).
Is there any way to get these history records directly connected to the job or to make a table view that will show data from multiple sources?