Forum Discussion

chetanpatil's avatar
chetanpatil
Qrew Cadet
8 years ago

i have a question regarding relationship can someone help me please

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?
App builders
Ask about Quickbase functionality
Relationships
  • MichelleMichell's avatar
    MichelleMichell
    Qrew Cadet
    8 years ago
    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!