Modeling Relationship

[Anonymous]

Hi all,

I try to build a connection between Date table and incident report table as follow,

Before connecting, using "incident date" and "Form ID" to creat a table like this,

However, after connecting Date table and incident table, the " Form ID" looks like being filtered. I can't figure out the reason, can someone help?

Thank you!!

[v-henryk-mstf]

Hi @Anonymous ,

This may be the result of an automatic aggregation calculation of the id field.

just like below:

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi,

I have addressed the issue . it is date type problem, one is date, one is date and time.

thank you!

[v-henryk-mstf]

Hi @Anonymous ,

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.😊

Best Regards,
Henry