I got a form (datasheet view) with all orders for one day, with a column which represents the delivered number...
Example:
Headlights, 10 ordered, 0 received
User changes the received field:
Headlights, 10 ordered, 4 received
What I would like to see happening is as follows:
The old line is removed, and instead of that 2 lines are added:
Headlights, 4 ordered, 4 received, Date()
Headlights, 6 ordered, 0 received
Now, for that I need to detect that when the form is altered, what line is altered so I can remove it and put the others in it's place...
I have absolutely no clue how to accomplish this (probably because it's monday morning here that should teach me not to behave like I do during the weekend )
Example:
Headlights, 10 ordered, 0 received
User changes the received field:
Headlights, 10 ordered, 4 received
What I would like to see happening is as follows:
The old line is removed, and instead of that 2 lines are added:
Headlights, 4 ordered, 4 received, Date()
Headlights, 6 ordered, 0 received
Now, for that I need to detect that when the form is altered, what line is altered so I can remove it and put the others in it's place...
I have absolutely no clue how to accomplish this (probably because it's monday morning here that should teach me not to behave like I do during the weekend )