This was intended to be an answer to this question. OTOH, it might be possible to improve upon it using eforms or better \href options.
The idea is to first create a PDF file containing the subtables.
\documentclass[multi=subtable]{standalone}
\usepackage{siunitx}
\usepackage{hyperref}
\newenvironment{subtable}[2]% #1 = target name, #2 = tabular columns
{\hypertarget{#1}\bgroup\begin{tabular}{#2}}% body goes here
{\end{tabular}\egroup}
\begin{document}
\begin{subtable}{first}{S|S}
\multicolumn{2}{c}{First}\\
{x} & {y}\\
\hline
1.0 & 3.2\\
1.5 & 2.9
\end{subtable}
\begin{subtable}{second}{S|S}
\multicolumn{2}{c}{Second}\\
{x} & {y}\\
\hline
1.0 & 3.2\\
1.5 & 2.9
\end{subtable}
\end{document}
Then use \href to link this file (test6.pdf) to the main document. Note the use of \# to add the anchors.
\documentclass{article}
\usepackage[colorlinks]{hyperref}
\begin{document}
\begin{table}
\belowcaptionskip=\abovecaptionskip
\abovecaptionskip=0pt
\caption{Main Table - click entries}
\centering
\begin{tabular}{cc}
&\href[pdfnewwindow]{test6.pdf\#first}{First} \\% note {first} is the target name
\href[pdfnewwindow]{test6.pdf\#second}{Second}
\end{tabular}
\end{table}
\end{document}
Note that each subtable starts up a new PDF viewer, so you can return by closing the page.
\#should not be necessary, simply#works fine for me. – Ulrike Fischer Sep 18 '19 at 15:27