Hi,
I have a company form and a exchange form.
A company belongs to one main exchange, but during the course of time it can change to become a member of other exchange.
In the Exchange form, I have made it easy so that the user can select a exchange,
The problem is when the company changes its membership from one exchange to the other, then it should keep in record of the previous membership in a different field(previous exchange field in the same table) and the time the change was made. Only the last change has to taken care of.
So please can any one help me with the ideas to code to achieve the above.
Thanks a lot.
Thanks for your time.
Regards
I have a company form and a exchange form.
A company belongs to one main exchange, but during the course of time it can change to become a member of other exchange.
In the Exchange form, I have made it easy so that the user can select a exchange,
The problem is when the company changes its membership from one exchange to the other, then it should keep in record of the previous membership in a different field(previous exchange field in the same table) and the time the change was made. Only the last change has to taken care of.
So please can any one help me with the ideas to code to achieve the above.
Thanks a lot.
Thanks for your time.
Regards
