Hi
Iโm trying to generate a report which will have values from different tables with same reference Id. The key in my โClientโ table is the reference in all other tables like โClient profileโ,โSpouseโ, โEmploymentโ table and etc. I have successfully pulled the data from my โClient profileโ table with the help of @tsuji_koichi but I donโt know how to pull the other data from other tables. Iโm currently working on pulling the data from my โEmploymentโ table but an error occurs.
Hereโs the error
Any help would be appreciated!
Thanks!
Is the [Company name] a column in your โEmploymentโ table?
Yes.
Then you need to read it just like <<[Complany name]>> without the dereference. You are already in a table โEmploymentโ with the Start: expression where that column is.
I tried but im not getting the email. Meaning no result or must be an expression error.
Iโm kind of confused on how to get the data here. Itโs working with my โClient profileโ table, Iโm not sure why itโs not working in my โEmploymentโ table.
Is it possible to access data from different tables using one reference id only?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |