Hi. on my form, the field are entered depending on availability. some fields are mandatory while others are optional. The mandatory fields are inserted into one table called Receipt while the optional ones are saved in the other table called receiptLine. When all the fields are filled in, then the two tables are updated. Otherwise when only the necessary fields are filled, the first table is not filled. instead an error is raised which is "String or binary data would be truncated. The statement has been terminated."
Look at the form below. The second panel is the one that is optional,
How should I solve it?