CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607483] |
Fri, 07 February 2014 02:40 |
bpmehta
Messages: 3 Registered: February 2006 Location: india
|
Junior Member |
|
|
Hi friends,
I am using oracle form 6i having multiple location data in one table now want to make such facility that if user change any field value by login in any one location system should ask for change this value to other location also?? How can I such generate effectivly.
any idea ...
|
|
|
|
Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607485 is a reply to message #607484] |
Fri, 07 February 2014 03:13 |
bpmehta
Messages: 3 Registered: February 2006 Location: india
|
Junior Member |
|
|
Thanks for respond , I want to say that
For example table itemmaster having ,
location code, material code , stock , unit,type
1155,MONITOR,10,NOS,INDENT
1155,OIL,5,LTR,INDENT
1100,MONITOR,5,BOX,INDENT
1199,MONITOR,15,BOX,REORDER
1188,OIL,15,KG,INDENT
as you can see that having different location wise record created now from form if I changed in location 1100 MONITOR unit from BOX to Nos system should asked that do you want to change for the same item in other location based record . So I donot need to update each location . I have given example for unit field if user change type filed then also system should ask for updation, User can not update locaton and Material code ...
|
|
|
|
|
|
|