Forum Discussion

Thim's avatar
Thim
Resolver V
7 years ago

Two linked tables, with changing data on one table

Hi All.   I am trying to avoid a potentiel issue that might come with one of my reports.   The issue is this.   I have our costumers phone number on two different tables. One is from an SQL Se...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Simply put you can't unless you link it based on a different identifier or maybe have 2 columns in SQL/ Excel tables - Current number/ Previous number? and then match against both

Thim's avatar
Thim
Resolver V
7 years ago

Sadly we do not store past data like that.

The SQL server is our costumer table, and will only store data at its current form.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Thim,

     

    What about creating another two index columns that won't be changed for the two tables to replace the phone number and create the realtionship with the index column?

     

    Best  Regards,

    Cherry

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Thim,

     

    Have you solved your problem?

     

    If you have solved, could you share your solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

    Best Regards,

    Cherry