@tsuji_koichi Hi. Actually, “Employment” table is like the “Client profile” table and has the same reference id from “Application” table. The Reference Id “Ispartof” of the “Client profile” and It wont pull the data from “Employment table” so I had to create another columns as Id for my different tables and turn on “Ispartof” but unfortunately appsheet doesn’t allow that. The below is my “Application” table
My data model is like this, I have a “Client” table with a key and that key is the key in all my tables: Client profile, Spouse, Employment, Co_borrower, Business and etc. What I’m trying to do is put all those data in a report and send it via email. I have already accomplished (with your,@tsuji_koichi’s help) the Client profile. Now I need to pull in the data from my other tables but I’m stuck.
Any help will be appreciated. Thanks!