Forum Discussion
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 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. :-)
4 Replies
- AnonymousNot applicable
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
- ThimResolver V
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-msftResident Rockstar
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