How to create table relationship model for this table?

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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
Photo of Syaeful Bahri

Syaeful Bahri

  • 102 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Debbie Smith

Debbie Smith, Certification Manager

  • 270 Points 250 badge 2x thumb
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.