Skip to main content
Question

How to create table relationship model for this table?

  • July 3, 2019
  • 0 replies
  • 20 views
I have table a with this field structure

Category | Header | Child Header | Description

And table b with this field structure

Date | Header | Child Header | Cost Project

There are two same fields between two table: Header and Child Header, the different is table b is not have category field

Each Category belong to one Header and one Header can have many Child Header

The idea is to create table c, which contains Category from table a and automatically show Cost Project from table b

Is there any solution to achieve this?

Many thanks, really appreciated
    This topic has been closed for replies.

    • DebbieSmith1
    • Quickbase Staff
    • July 3, 2019
    Hi Syaeful,
    You could do this with just 2 tables. You can create a relationship between table  a and  table b and then use a summary field to total all of the Child Header- Cost Projects by  Header and create a report that shows the Header and Cost Project.
    Terms & ConditionsAccessibility statement