• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Table track updates

Theexpat

Firstly, Welcome to the Chandoo.org Forums

I understand what you have asked for 111 and adding S2
But why doesn't the same apply to the others eg: 222 as shown below?

upload_2016-9-28_14-50-47.png

can you please explain why it only applies to one and when it should apply to other lines?
 
Thanks for quick reply
It will apply to any product IF its stage get updated only.
Why apply it to product 222 if it's stage remians the same.

Table1 gets it's data updated from another source.
If the product stage is not updated it will appear in table2 as it's in table 1
Hope this clarify sorry english is a second language
 
When you say it's stage gets updated, does that mean just the Time Changes ?
 
The stage updated at spicific time.
So i want the new information(the new stage and the new time ) to be tracked in the new table2 .
I want to track the stages each product pass through
I.e
Table1
Pro1 s1
Table2
Pro1 s1

Table1
Pro1 s2
Table2
Pro1 s1
Pro1 s2

Table1
Pro1 s3
Table2
Pro1 s1
Pro1 s2
Pro1 s3
So table2 track the changes in the stages
Forget about the timing now just do this part for me plz
All the coding should be done on table2
 
You must log in or register to reply here.
Back
Top