I have two table lvmhn114 and lvmhn113
Two session lvmhn1114m000 and lvmhn1113m000
After opening lvmhn1114m000 session i enter some field in which index is
lvmhn114.gpno, lvmhn114.date, lvmhn114.suno

1. Afterfilling all fields there is one button on the same session which calls another session after clicking on the button this session opens lvmhn1113m000. In this session I want the same data what i entered in previous session i.e. lvmhn114.gpno, lvmhn114.date, lvmhn114.suno. My second session is of TYPE 3 and First Session is of TYPE 1 (lvmhn1114m000).

2. If data is available in 2nd session i.e. lvmhn1113m000 then users should not be able to delete the data from 1st session i.e lvmhn1114m000. If they want to delete then first he should delete data from 2nd session then after he can delete the data from 1st session.

3. If any user is updating the data in second session for say Gate Pass No. 1 then at that time no other users should update the same record.

plzzzzzzz help me i m trying it from so many days but not able to solve all three problem. If any one can help me out. Thanks in advance.

Im assuming you are on baan 4.

1. In session lvmhn1114m000 export the three index fields using export().
2. In session lvmhn1113m000 import the three index fields using import().
3. Use query.extension in session lvmhn1113m000 in before.program section
(This will restrict the records).
4. In session lvmhn1114m000 before deletion you can checek whether all records in lvmhn113 are deleted.

Bye.

Tons of thank to you jack for ur quick response..............
but i already tried all export , import command and i am not able to get the data.
If you can tell me exact code what i need to write and in which section then it would be better. I am new in customization. So plz help me.
1. Give me the exact code for exporting the data from lvmhn1114m000.
Fields are lvmhn114.gpno, lvmhn114.date, lvmhn114.suno
2. Importing the data in lvmhn1113m000
For this session fields are lvmhn113.gpno, lvmhn113.date, lvmhn113.suno where data has to store.
3. Can u plz give me exact code for writing query.extension in session lvmhn1113m000 in before.program, so that user can not modify the same record in lvmhn1113m000 session at same time.
4. How to check in lvmhn1114m000 session that all data has deleted from lvmhn1113m000 and then user can delete the data from lvmhn1114m000.
Plzzzz do tell me exact code of my requirement i.e. in which section and what script to write thats why i have given the full informaion. I m new in coding. So plz help me. Thanks in advance.