Skip to main content
Question

Table Relationship

  • May 10, 2021
  • 0 replies
  • 21 views

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

This topic has been closed for replies.

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/
------------------------------
Terms & ConditionsAccessibility statement