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 helpful to show the comparison in the report so trying to create One to One relationship between the Actual Hour table, Forecast Hour table. (One Actual Hour can have one Forecast for a project).Please help



------------------------------
Mahe
------------------------------

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/
    ------------------------------