Can the info in the field of a non related record in another table be shown in a field?

I have a table that holds information that an automation setup by someone else puts info into a record when it's created.  The records aren't related when this happens, it just pulls data initially in...