How to create table relationship model for this table?
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
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
