Forum Discussion

JuanSolorio1's avatar
JuanSolorio1
Qrew Cadet
5 years ago

How to generate report of records related in many-to-many relationshipts

Hello everyone, Please see attached ERD section for reference. The goal is as follows: 1. I need to be able to generate a report for USERS listing all ELEMENTs that a...
Relationships
reports and charts
JuanSolorio1's avatar
JuanSolorio1
Qrew Cadet
5 years ago
Thanks, Mark!

We had implemented a similar approach with an intermediary table. However, the roadblock we came across was that only one User (or Element) could be viewed at a time. If multiple people were attempting to view these reports simultaneously, they would not be able to because the single record in the intermediary table keeps getting overwritten every time they click the button. Nevertheless, it is the closest we have come to what we are looking for, and it definitely does what we need it to do.

Thanks again!

J

------------------------------
Juan Solorio
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
I do have another approach which I can implement, where the User Focus is stored in a self maintaining table of Users where the Key field is the Userid. But I don't think it's needed, because the click only has to last long enough to refresh the record and see the result. 


------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------