Pull in values with a connection

On my home page, I am using a Connection to a table to display a range of options for an event outcome - minor, major and catastrophic. In that second table (Event Outcome)I also have a score associated with the event outcome which I want to access in an equation on the page.

The fields are “Outcome” - (text field) and “Score”.

How can I pull in that Score field from the connected “Event Outcome” table and use it in an equation on my main page?

Thanks for your help.