
Hello everyone,
I have created a new form with a header table and a line table as data sources. The line table includes a LineNumber field, which increments automatically whenever a user creates a new record (e.g., by clicking the Add Line button). The Add Line button is a command button of type 'New', with the Save Record property set to Yes.
However, I've encountered an issue: if the user repeatedly clicks the Add Line button, multiple blank records are created. Even though I have a Product field marked as mandatory, these blank records are still being generated, all with the same LineNumber value of 1 (The LineNumber generation is based on existing records in the database tied to the same header reference).
This behavior is causing problems for users. As I understand it, shouldn't the standard logic for line creation should prevent duplicate blank records and display an error message if a user tries to add a new line without completing the previous one?
Is this the expected behavior and is there anything that I should have done? Any insights would be appreciated!
Thanks,
Waed Ayyad
If this helped, please mark it as "Verified" for others facing the same issue