ADO inserting new records

[André]

Hello there:
I'm having a problem when trying to add new records using ADO:

First I call a Stored procedure that joins two tables.

Then When I try to run the rs.AddNew with new value fields I get an Error like this:

INSERT statement conflicted with column foreign key constraint ...

How can I insert new custommers to my database then??

Do I have to hand write it??

Any ideas to what I'm doing wrong??

Please help

thanx and regards
André

[Clunietp]

Update the two tables separately instead of the joined table