How to lookup a text field inside a linked record's linked field?

Hi!

So I have a linked record in my table ‘Communiques’ to a record from (‘Contacts’) and I have a lookup field for that record’s Account field - which is a linked record to the Account table. In the Account table I have a text field for ‘Website’. What I would like to do is show this ‘Website’ record in my ‘Communiques’ table.

Hope that makes sense!

You can see a video of what I mean below:

Thanks a lot!

The [Contacts] table needs a Lookup-field for the [Account]'s {Website} field.

Your {Website} field in your [Communiques] table would be a Lookup field that looks up the value of [Contact]'s Lookup field.