I have searched the forum but can't quite find what i am looking for on this.
I have form1 that has the current commodity
When i need to change the commodity I want the following to happen when they click a button:
- open the commodity change form
- that form has a drop down to select a new commodity and a date of commodity change date field
- When the user submits it will move existing value to history along with the Date of change (separate table)
- Next it will take the value in the new commodity box and make it the current commodity
My thinking is that when i click the button to open the change form I can save the commodity at that time but I wont have the date yet. Just not sure of they best way to go about this.
Thanks for any help