Forum Discussion

SyaefulBahri2's avatar
SyaefulBahri2
Qrew Member
5 years ago

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...
App builders
Relationships
Tables and fields
DebbieSmith1's avatar
DebbieSmith1
Qrew Cadet
5 years ago
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.