Let's discuss in general terms first. The text obvious does not know the Record ID# of the job. But I presume it knows the the mobile # which sent the text. Does the job know that? If so you can populate that into the text record ( maybe you already do that) and then trigger a Pipeline to scan for jobs which have that mobile #, finding the first Job, and write the Record ID to the respect, thus linking it.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
