Jeanne Boyarsky wrote:Ramses,
Are you thinking of an updateable resultset maybe?
Hi Jeanne,
Hmm.. i'm not sure.. let me describe what i got here..
There are 3 tables.. part master, part detail, stock. One item subject in part master contain
several item parts.. So when parts came in to warehouse, it should insert part detail based on each subject in part master table.. After that it should automatically update stock table..
e.g. subject A has 10 item ( B - K ).. And i should check each row , write to part detail and based on
each row , update data in stock.. We have more and less 200 subject and each subject contain more and less 30 item parts..
And all transaction daily..
I hope you can get what i mean...
Any suggestion on that jeanne??