2 Joined Tables in Stored Procedure - Update Data in Both?

[gazzippy]

I have read that you can only update one underlying tables data in a stored procedure.

I am Using an Access Form (in 2000 ADP) bound to a stored procedure but can only Edit data in table specified in UniqueTable property, does anybody know of a way to edit data in both tables using the same form showing all fields I require?

Many Thanks

 

[rajeevnandanmishra]

Hi gazzippy,

I am not sure about the dealing of Access forms. You better put your question in the Access forum.

But as regarding the stored procedures, Yes, You can insert/update/delete multiple tables from the stored procedure.



raj