On the same theme, you could make a 3rd table. Then create two saved table to table copies to copy the data from each of the two tables into the 3rd table.
then create a formula URL button to
1. purge the third table
2. import from table 1
3. Import from table 2
4. Run you report.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 06-03-2022 08:50
From: Katlyn Allen
Subject: Reports Pulling Data from 2 Tables at once
Probably not the perfect solution - but you could set up a pipeline that copies/updates records in a third table any time a record is created or changed in the first two tables, then make the report in the third table.
------------------------------
Katlyn Allen
kallen@eatatjacks.com
Original Message:
Sent: 06-02-2022 15:37
From: Anthony Wong
Subject: Reports Pulling Data from 2 Tables at once
Hello,
I have 2 tables that separate projects from my internal team, and external team.
I would like to pull a single report that shows both entries and information regarding the projects in both tables.
However, it looks like I haven't found a way to do this. Can someone support me in identifying if this is possible?
Thank you so much
------------------------------
Anthony Wong
------------------------------