Forum Discussion

FraChi's avatar
FraChi
Regular Visitor
6 years ago
Solved

Relationship Date/Time Column

Hello,   I am trying to make a relationship between two columns of different tables having Date/Time format with no success. See screenshot below:   I tried cardinality Many to Many but th...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi FraChi ,

     

    These two columns can't find the corresponding value at all.

    For example, I have two tables like these.

    (Table2)

    (Table1)

    I got this when I create a relationship between the two tables:

    So you should create relationship between [Ring] column with [Ring[#]] column.

     

    Best regards,
    Lionel Chen

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

FraChi's avatar
FraChi
Regular Visitor
6 years ago

Any idea why the relationship between StartDate of Table1 and Start Date [yyyy-mm-dd hh:mm:ss] of Table 2does not work?

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi FraChi ,

 

These two columns can't find the corresponding value at all.

For example, I have two tables like these.

(Table2)

(Table1)

I got this when I create a relationship between the two tables:

So you should create relationship between [Ring] column with [Ring[#]] column.

 

Best regards,
Lionel Chen

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