topic Re: How to use a calendar for more than one table? in App Development

How to use a calendar for more than one table?

edugallowk — Sat, 16 Nov 2024 21:00:07 GMT

Hello guys!

How do I solve this problem?
Please kindly help me.

I need the master calendar to interact with the table data (FAT) and with the table (INS). Both tables have dd / mm / yyyy date with the name 'competence'.

If I keep the same name in both tables I fall into the synthetic key problem and if I put different names, then the circular reference error occurs.

Circular reference: One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop (s) will automatically be cut by setting one or more tables as loosely coupled. Use Loosen Table script statement to explicitly declare loosely coupled tables .: return.

Please help me!

Thanks for the attention and big hug.

🙂

Re: How to use a calendar for more than one table?

Anil_Babu_Samineni — Wed, 24 Apr 2019 04:35:03 GMT

Create the composite key which generate the syn key to map into calendar table. Check if that helps link-table

Re: How to use a calendar for more than one table?

jonathandienst — Wed, 24 Apr 2019 05:46:24 GMT

A composite key will not resolve the circular reference. This data model needs some rework. You could concatenate the fact tables (it does not matter if they don't have many common fields), or (more likely in this case) link the tables through a link table.