I have created a form using vb.net.
The form has the following fields and a Datagrid:
a. Revision
b. Installation
c. Part No
d. Qty
e. Description
f. Change Rev (Field is Disable - autofill based on criteria)
The form also has the command buttons: Save and Close
For initial revision "-", I am able to capture and saved what was key-in the above fields (except "Change Rev").
For making subsequent revision, "A" (for example), the previous revision data is recaptured onto the fields.
However, I have a problem. Is it possible when there is any changes made to any of the following field (Part
No, Qty and Description) that is different from the previous revision, the field "Change Rev" will auto-fill
the current revision "A" in Change Rev. The purpose is to tell the user which set of data is change and in
what revision, if there is no change make to data, the Change Rev remain as "".
Example:
Rev Installation Part No Qty Description Change Rev
- -1001 - - ENGINE
- -1001 123-1 1 HANDLE
- -1001 765-N1 1 HOLDER
-----------------------------------------------------------------
A -1001 - - ENGINE
A -1001 123-12A 2 HANDLE CASE A
A -1001 765-M3 1 HOLDER
-----------------------------------------------------------------
Any advise how to approach the above is appreciated. Thanks
The form has the following fields and a Datagrid:
a. Revision
b. Installation
c. Part No
d. Qty
e. Description
f. Change Rev (Field is Disable - autofill based on criteria)
The form also has the command buttons: Save and Close
For initial revision "-", I am able to capture and saved what was key-in the above fields (except "Change Rev").
For making subsequent revision, "A" (for example), the previous revision data is recaptured onto the fields.
However, I have a problem. Is it possible when there is any changes made to any of the following field (Part
No, Qty and Description) that is different from the previous revision, the field "Change Rev" will auto-fill
the current revision "A" in Change Rev. The purpose is to tell the user which set of data is change and in
what revision, if there is no change make to data, the Change Rev remain as "".
Example:
Rev Installation Part No Qty Description Change Rev
- -1001 - - ENGINE
- -1001 123-1 1 HANDLE
- -1001 765-N1 1 HOLDER
-----------------------------------------------------------------
A -1001 - - ENGINE
A -1001 123-12A 2 HANDLE CASE A
A -1001 765-M3 1 HOLDER
-----------------------------------------------------------------
Any advise how to approach the above is appreciated. Thanks