Please could someone give me some advice about the following:
I have 4 forms in a writer document. Each form is used to add a record to a different table of the database bound to the forms:
* Transaction form --> adds record to Transaction table
* Location form --> adds record to Location table
* Entity form --> adds record to Entity table
* Category form --> adds record to Category table
You can see a (partial) screenshot of the writer document below:
As you can see there's an error in the screenshot. This error is produced when I enter values on the transaction form and then click on any of the other forms BEFORE
completing all mandatory transaction fields. As I understand it, the cause for the error is twofold:
1. When I click of the form the user input is automatically sent to the database for insertion
2. The insertion of the input into the transaction database table fails because mandatory information is missing
Can the behaviour in point 1 be changed? Is it possible to prevent the data from being sent/saved to the database when the form loses focus? In other words: how can I click between forms without the input being autosaved? If not possible, what are some workarounds?
A good reason for me to want this kind of behaviour is the following scenario: imagine I am entering data on the transaction form. At some point I want to select a receiver from the drop down list, but realise the receiver does not yet exist in the database. So I need to go ahead and add a new entity to the database. Currently this is not possible for me unless I either ...
a) complete all mandatory fields including the receiver field (e.g. use a dummy value which I then need to change later) or ...
b) discard all data and start over.
Any advice is much appreciated,
Mattias
EDIT: reworded some of the sentences to clarify the topic.
