ContributionsMost RecentMost LikesSolutionsi have a question regarding relationship can someone help me pleaseMy 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?Re: Creating monthly report?I want to create a table not the summary report. The new fields will be entered manually and used for calculation. Can you guide me how can i create new table containing data from Purchase orders table grouped by monthly. ThanksRe: troubleshoot issue related to dataThank you very much but the data is confidential so I cant share. Can you guide me how to create a table where I can get the data grouped by monthly. (I don't want to create summary report)Re: troubleshoot issue related to dataPO tables contains purchase orders and date of the purchase. Performance table is created to track various metrics and do calculations. The data in performance table is grouped by months that is the date period which is prepopulated by month and year (ex 072017 ). In PO table, I dont know how related overhead expense was/is used to relate two tables. Any idea how is it implemented? My guess is there was a table overhead expense which might be deleted or renamed after Dec 2016 and now I am not able to figure out how can i get the data for year 2017 as the relation between two tables is broken.troubleshoot issue related to dataI have two tables Performance and PO. Performance is connected to PO using one to many relationship. The key field of performance is Date period (ex 072017) and reference field is related overhead expense in PO table. Now the problem is after 2016 data is not getting populated because there is no data in related overhead expense field (i guess this field should be auto generated). Can anyone tell me what might be the problem here?Re: Creating monthly report?I want to add few more fields in new table and do different calculations and create graphs but I need the data monthly.Creating monthly report?I have table which contains purchase orders and i want to create a new table which will have all the metrics and summary of purchases grouped by month. How can i create this new table?. How should I create relationship between new table and purchase order? Thank youRe: Get data from multiple tablesThank you. I got it figured out. I just added lookup fields in shipping and transactions tables to get the needed data. Then i just created the report in transaction table instead of Order table.Re: Get data from multiple tablesActually one transaction has only one number associated with it. I am working on other person's app and don't know the exact logical flow of data.Get data from multiple tablesI am creating the report to extract the data from multiple tables. Now i just need the data from a table which i am not able to figure out. I have 4 tables Order, Shipping, transactions and numbers relation is order < shipping < transactions > numbers (1 order has many shipping ,1shippinghas manytransactions, 1 number has many transactions) i want to get the related data from numbers in order table how can i do it?