Forum Discussion

HemaRajendran1's avatar
HemaRajendran1
Qrew Trainee
4 years ago

Table Relationship

Hi Folks, How to do one to one relationship? I want to create Actual Vs forecast hours report to show the user progress in the manager dashboard. Forecast hour as a summary field will be really help...
Relationships
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
4 years ago
A true 1-1 relationship is not possible in Quickbase. Instead, you may want to create a 3rd table that would act as a Parent to both the Actual and Forecast tables. This could be the 'Hours' table and you could then bring up the Actual and Forecast amounts and compare them on that table.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------