it's me again.
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 filled in automatically when the user opens the form.
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.
how can this field also be filled in the database table?
View Complete Post