hi,
i want to know how can i add new records to a sql database table that has a foreign key relationship with another table using infopath form.
i have created a blank form based on database
i have all my fields and the "add new" button already in the form.
i have the username and the userid and some other fields filled in automatically when the user opens the form.
i want that the user does not have to fill in his name, id and some other fields everytime he opens the form.
only a part of the form like new vacation days must be filled in as new. so when the user click on the "add new" button i dont want that it clears all the fields. i want it to only set the new vacation days as new fields to fill in.
when i fill in the form with new data and click submit. it gives me this error:
Field or group: BE_CODE
Error: Only integers allowed
this "BE_CODE" field has to be filled in the database table, it can not be null. but it must not be filled in by the user it self. and it is a repeating table so it can not be auto increment.
is there an easy way to do this?