VB recordset with Sybase SQL Anywhere
Posted on 2002-05-16
Suppose I have 2 tables:
PK noCust PK noContact
noCust and noContact have a default value of autoincrement.
My problem is that, with MS Access 97, I can't had a customer and a contact at the same time:
rstCust!nameCust = Me.nameCust
rstContacts!nameContact = Me.nameContact
ERROR-> rstContacts!noCust = rstCust.noCust
I have a message that says that my record has been deleted. Is there a way (there should be) to make this work? All I want to do is to add those records in the same "transaction".
Any help would be appreciated, thanks