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

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

Community Page
Last updated: