is there any way a transaction (standard or custom) and/or a support ticket can interact with a standalone custom record?

Yes if you create a join between the 2 Add a custom field to your transaction Type = list/record Record = (your standalone custom record) Then go to a transaction and assign your custom record(s) to it Now you have a join between the two