Dear All,
I am sorry if this message not suitable posted in this group.
I have a table
company id exhibition id version tel fax contact
person
1 1 1 999 9999
Mr. white
1 1 2 888 9999
Mr. white
2 1 2 123 456
Mr. Black
3 1 2 232 333
Mr. Yellow
Now, I need to write a function which specification as follow:
our client can check the latest five version of the table, and when they
click on one version, its content MUST be compared with its' previous
version so as to display what infomation the company changed.
For example, when client click on version 2, the result should like as
follow
company id exhibition id version tel fax contact
person
1 1 2 888 9999
Mr. Borrow
2 1 2 123 456
Mr. Black
3 1 2 232 333
Mr. Yellow
From above result, it indicated that company who with id 1 have updated
their information in version 2
and other two company is not exist in version 1, so it change to red in
color.
According to the above requirement, I only have one solution, retrieve the
selected version and its' previous version, and compare each fields in
selected version with its' previous version, if different, change it to red
in color, am I right?
I am appreciate you if you can provide some suggestion to me.