i have a question regarding relationship can someone help me please

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
My first question is probably very easy. When relationship is created how quickbase matches the records from master table to the records in detail tables. By default, Record ID and related (table name) is created, so how related field is created in detail table?

Second question is I want to create a table where I want to get the data from purchase orders table grouped by month. Purchase order table contains date of purchase. How can i create new table?
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb
To answer your first question, you would need to change the Key field for your master table (Record ID is the default).  You can do this by going to your table > Settings > Fields.  Check the box of the field you want to use as your key, and select "Set Key". Now, when you create the relationship, your tables will be connected based off that field.

For your second question, you can create a Summary Report from your purchase order table.  Go to your existing purchase order table, click "Reports and Charts", click "New", then select "Summary Report".  Choose the fields you want to summarize under "Summarize Data".  From there, scroll down to "Grouping and Crosstabs", group by Date of Purchase, and Combine by Month.  This will create a summary report grouped by Month.  

I hope this helps!