Two linked tables, with changing data on one table

[Thim]

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 Server, and another is in an Excel Sheet.

I need to link the SQL and excel sheet by the phone number. Easy enogh.

My issue is, how do i avoid this link to break on costumers who changes their phone number.

The number would automaticly change/update in the SQL table, but not in the excel sheet.

Any ideas, how i can avoid this break, without manually update the phone number on the Excel sheet every time?

Thank you in advance. 🙂

[Anonymous]

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]

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]

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

[v-piga-msft]

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