Dear guys,
Just tell me how to update multiple table in a database(access2000).
Mahadevan
Printable View
Dear guys,
Just tell me how to update multiple table in a database(access2000).
Mahadevan
Need a bit more info...
Is it the same bit of data into multiple tables? If so maybe the database structure should be changed to be more relational or maybe just do it by enforcing referential integrity (cascading updates) in the database table relationships.
Hope that helps
Dear iandarbyshire,
Thank u so much for responding me.
1.Its like this I have five tables(i.e.,two input tables,two output tables,one master table)
2.Both the input table have few common fields
3.Both the output table have few common fields
4.Master has a field common to all the tables.
Just send the code or the procedure to update the tables.
Regards
Mahadevan