Let $\Sigma$ be a covariance matrix (symmetric positive-definite), and $\Omega = \Sigma^{-1}$ the corresponding precision matrix, which is also SPD (the quotients of positive eigenvalues are positive).
Let $T$ and $U$ be the upper-triangular Cholesky factors respectively of $\Sigma$ and $\Omega$, such that: $$ \Sigma = T^t T \qquad\text{and}\qquad \Omega = U^t U $$ writing down the inverse of $\Sigma$ explicitly, we also have: $$ \Sigma^{-1} = T^{-1} T^{-t} = \Omega = U^t U $$ and similarly the other way around, writing down the inverse of $\Omega$.
In this equality, we have a product of upper-times-lower triangular matrices on the left $T^{-1} T^{-t}$, and a product of lower-times-upper on the right $U^t U$. I get confused with such equations, and am not sure what to do next; considering products like $\Sigma\Omega$ do not lead anywhere (that I can see). Can we say anything about how $T$ and $U$ are related?
(Could not edit the answer of @user8675309, so here is a cleaner derivation.)
The main equality relating $T$ and $U$ is: $$ T^{-1} T^{-t} = U^t U $$
Multiplying by $T$ on the left, and $T^t$ on the right, the left-hand side becomes the identity: $$ I = T U^t\ U T^t = (U T^t)^t\ UT^t $$
so the matrix $Q=UT^t$ is orthogonal. We can then write: $$ T^{-t} = Q^t\ Q\ T^{-t} = Q^t\ UT^t\ T^{-t} = Q^t\ U $$
where we "recognize" the QR decomposition of $T^{-t}$. Uniqueness follows since the Cholesky factorization is unique for PD matrices.