Using data in repeated table to filter and display data from another table

[differenceweb_ben]

Hi All,

I’ve got a table showing some booking information here:

What I’m wanting to do is use the “customerid” for each booking and replace that with the customer name from the customers table (filtering the customer name by the customer ID in each row here)

I’ve tried creating a query from customer table and filtering it this way (see screenshot)

but when it’s not outputting anything to the page in that table cell (table cell just still shows 1) - any text at all I put inside the <td> just doesnt appear - I’m assuming this is because it’s a dynamically generated table - was wondering whether someone might be able to point me in the right direction - or explain best practice with this?

Thanks,
Ben

[ben]

Add both tables into the one action step and do an inner join.

https://www.w3schools.com/sql/sql_join_inner.asp

[differenceweb_ben]

I’m ashamed that in over 15 years of web development I’ve never seen or used this command.

THANK YOU @ben

I’ve been tearing my hair out all day on how to do this!!