Use multiple tables in one PDF Template

[RogerCreasy]

I have a pricing app that uses 4 tables -

1. JobBasics - Contains basic info about the job being priced e.g. customer, description, timestamp
2. JobDetails - Contains the details about the job being priced, i.e. the quantity of each item on the job
3. JobPrice - contains the price the customer is being charged for each item on the job. We store this, rather than using a lookup so that we can reference the then-current price we charged the customer
4. JobAmt - the Quantity from job details * the price from JobPrice - stored rather than calculated on the fly for reporting purposes. I am using this table as my primary table for the template.

Each table has a key column "PriceID". The relationship is 1:1 for the rows

Each Job can have 75+ items included. We are doing separate tables to get past the AppSheet 100 column limit.

I need to generate a PDF that can be sent to the customer. This report must have the quantity, price, and total. I am using a Google Doc with a table as the template. 

I cannot get the template to use multiple tables. I have successfully added the JobAmt data with no problem. S0, my basic template "works".

I tried in one Google Doc table cell:

<<Start: JobDetails[PriceID]>><<[PriceID].[Inches]>><<End>>

 I also tried using a SELECT a few different ways.

Can anyone give me pointers?