Link a column to another table's column data - sqlite

I have some text in a SQLite database. Let it be "This is a link." What I want is when a user clicks "link", I want to display text from some different table's column. I know I can do this by passing the table's name and an ID to display a specific text but I am unable to figure out how to send the table's name and an ID in that text.

In html, I can do this by

<a href="filename">link</a>

But I don't want to open an HTML file, instead specify a table and an ID.

Any help is appreciated