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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Wait, you are trying to create a relationship between Start Date in Table1 and Ring # in Table 2?

FraChi's avatar
FraChi
Regular Visitor
6 years ago

I am trying to make a relationship between StartDate of Table1 and Start Date [yyyy-mm-dd hh:mm:ss] of Table 2.

  • 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.