rj1234
18th November 2004, 18:56
I have a maintain session which uses Form 3 Multioccurance in which there is one multioccuring field which is not a database field e.g if I am maintaining records of tdsls040 and i want a string field against it giving reason for blocking the sales order which is not a part of the tdsls040 but after user saves it I have to insert it into one of my customised table i.e Order No and the field value stored against it.The field is an array which uses the predefined variable actual.occ to store the contents of the string entered by the user.The session works fine if user follows the tab sequence for maintaining records.The problem comes when the user clicks randomly anywhere on the form other than in the field.The text field gets overwritten by what is latest typed by the user
e.g
Record 1 has text as "Blocked"
Record 2 has text as "Not yet Blocked"
So now ur actual.occ has become 2
If the cursor is moved anywhere else on the form and brought back to Record 1 i.e not on any field but by just selecting that record it will show as "Not yet Blocked" instead of the value entered by user i.e "Blocked".this happens because the value of actual.occ variable remains as 2 when actually u have clicked on record 1.

Is it that we cant use any field in multioccurance if it is not a database field ???


Regards
Rekha

mark_h
19th November 2004, 15:30
Maybe if you post the code someone will see what is causing the problem. The one question I have is why the form field is an array. I have used qkey to add fields like this to mutli-occurance forms, but I did not use the field as an array. What I did was use a field like somefield.cmnt as the multi-occurance field. Then in one of the before.display fields on the detail line I would go look up the value of the field on another table.

Mark