Forum Discussion

Qrew Cadet

4 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

MarkShnier__You

Qrew Legend

4 years ago

Is it a requirement that this be a report or would it be good enough to be able to click a button on a user and see an embedded report of all the elements and conversely set on an element record and click a button to see all of the users involved?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

JuanSolorio1
Qrew Cadet
4 years ago
Hi Mark,

The button option would definitely suffice.

J.

------------------------------
Juan Solorio
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  Can you tell me what the Key Field is of users. And also what is the Key field of elements?
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - JuanSolorio1
    Qrew Cadet
    4 years ago
    Record ID# in both instances.
    
    ------------------------------
    Juan Solorio
    ------------------------------