Error in updating fields

[Kookai]

Hi all,



I have form coming from diferrent tables. And when i try to input a data...

Error is saying that joint key of table "name" is not in recordset. i found out that if i have input my data to first 3 fields which are from my first table i need to save it so i can input data to other fields which are from my second table.

Why its not autmatic saving? what do i need to do to have it save automatically.

Please help me

[pkstormy]

Do you have a table called "name"? If so, immediately rename it and re-code accordingly (don't use reserved names!)

Otherwise, you need to look at what fields are required to add a new record to the table. If this is a relational design, you may need to update certain fields. Or you are trying to save a "partial" record and other required fields are not supplied when updating.

"Why its not autmatic saving? what do i need to do to have it save automatically." - there's many possible reasons to this question.