I have a table, called my Sync table, that I link whatever I need into several different tables. I want to add long-text columns to my Sync table and then hyperlink the fields. I then want to lookup those fields in all of the different tables that I'm syncing into.
However, when I've tried to do this I've noticed that only the text is transferred to the Lookup field in the new table, but the text is not hyperlinked. Is there a workaround for this?