Discussions

Expand all | Collapse all

How to create table relationship model for this table?

  • 1.  How to create table relationship model for this table?

    Posted 07-03-2019 06:38
    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


  • 2.  RE: How to create table relationship model for this table?

    Posted 07-03-2019 16:53
    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.