Hi,
I have a Access 2003 DB, which is split in a backend and a frontend.
Backend has two tables (which are relevant for this question):
Articles (Artnr, Price and so on)
CampaignWeek (Artnr, Week and so on)
Artnr in Articles has a 1:N relation to Artnr in CampaignWeek.
In a form, which has fields both from Articles and CamapignWeek the user can enter info.
In the AfterUpdate event on the textfield containing CampaignWeek.Artnr, I check if the entered Article number allready exists in table Article. If not, I insert it during this event.
When I go to another record or close the form, I suppose Access does the actual insert. However, then I get the error message that "The Microsoft Jet database engine cannot find a record in table 'Articles' with key matching field(s) 'Artnr'." I check the Article table, and see that the insert is successfull. Any idea why Access doesn't recognize this?
/henkus
I have a Access 2003 DB, which is split in a backend and a frontend.
Backend has two tables (which are relevant for this question):
Articles (Artnr, Price and so on)
CampaignWeek (Artnr, Week and so on)
Artnr in Articles has a 1:N relation to Artnr in CampaignWeek.
In a form, which has fields both from Articles and CamapignWeek the user can enter info.
In the AfterUpdate event on the textfield containing CampaignWeek.Artnr, I check if the entered Article number allready exists in table Article. If not, I insert it during this event.
When I go to another record or close the form, I suppose Access does the actual insert. However, then I get the error message that "The Microsoft Jet database engine cannot find a record in table 'Articles' with key matching field(s) 'Artnr'." I check the Article table, and see that the insert is successfull. Any idea why Access doesn't recognize this?
/henkus