About connection between two main tables

[sevvalk]

I have two main tables; fg_satspd and fg_satssk. fg_satsppd is order table and fg_satssk is the table where complaint records are kept. These tables mean different things. They have no unique fields. But I want to see, for example, how many complaints were received and how many orders were received on 01.02.2024, all together in a table. I created a master calendar to select 01.02.2024 as the date once.

I made a connection between this tables. These tables have date fields. I created a master calendar for these date fields. And that's where I made the connection.

but there is a table that I need to connect from the store code field that is in both tables. This table is fg_chschk.

For example, when I select the store and date;
Leaving store A in 2023. Order and complaint arrived?
How do I establish relationships between these tables?

[Aditya_Chitale]

You can concatenate tables fg_satspd & fg_satssk and link this concatenated table with master calendar on basis of date field and link the same with fg_chschk on the basis of store code.

But while concatenating, make sure to add a unique flag field in both tables to identify table source of the data

Regards,

Aditya

[sevvalk]

Table fg_satspd and fg_satssk have no fields in common. How do I concatenate it?

[Aditya_Chitale]

You can force concatenate them as they have common date & store code fields. 

Regards,

Aditya