Hello,
I am developing a lotus application for purchase requests. The requirements are simple, on a main form enter the details for the purchase request. Then there should be a button on the form opening a dialog box with a subform where the user fills the item info. When clicking ok, the dialog box closes, and the item is added to a table on the main form.
using @dialogbox, this was successful but only for one record. Now, everytime I click on the button, the same form opens, and is treated as an update. I cannot create any new items
Can someone help me with this?
Thanks
Subject: same field name
It sounds like your dialog box is writing to a particular field in a table. The subsequent runs just overwrite the data in that same field. You need to find a way that subsequent runs would write to a different field (or set of fields). Of course, doing it this way you have to code all the possible fields into the form, and you would have a limit on how many table rows you could display.
Another, possibly better, way to do this is to use a form with an embedded single-category view. The category would be a unique field on this document - such as a PO#. The dialog box would create a new document with this unique field included. The embedded view would be categorized by the unique field. You’d probably need to do some kind of refresh to the document after populating the dialog and hitting OK.