Possible to create a report based on 2 tables.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
i want to create a report from multiple tables 
Photo of v

v

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
Can you  tell us more about these two tables? Is there any relationship between the two tables, i.e. is one inherently the parent and the other connected as a child records.
Photo of v

v

  • 0 Points
No we don't have any relationship between those two tables
Photo of Neal

Neal

  • 70 Points
Please explain your business case. Then I can provide spreadsheet screenshot prototype .
Photo of v

v

  • 0 Points
Thanks in Advance,

I am having two tables one is  Data and another is Data Details . So in the table Data there is a field "item"  and in Data Details Table "item" and "item No" which is having one to many relationships [one item having many item no] . So i need a report  of "item" (i.e., from Table -> Data)
and "item No" (i.e, from Table -> Data Details).  There is no relationship with these two tables !!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
"V", can you clarify what fields you want to show on the report?  but in any event, if there are fields on the Data table that you want to show on a report run off the Data Details table, then you will need to make a relationship where One Data has Many Data Details.  

To make that relationship, you would need to set the Key field of your Data table to the "Item" (assuming that is the unique Identifier of the Data records) and then on the right hand side of the relationship, use the similar Item field from the Data Details table.  Then once that relationship is in place you can add look up fields from the Parent data table down to the child Data Details table.
Photo of Neal

Neal

  • 70 Points
I have created Spreadsheet Screenshot Prototype.

Neal

NealPatil @ gmx.com