M
Mrs. Ellis
Hi there, I would like for my Product table to deduct appropriate values for
materials used during a work order, however, I am not sure exactly how to do
this. I already have tables set up with relationships to accomodate incoming
purchases modeled on the Northwind example, but should I set up a seperate
set of tables for materials used, or can I modify my existing tables to track
both purchases and usage? I'm pretty sure I will need to use a subform on my
work order form to show the parts used, but I am not positive how to set up
the tables. I visited the Allen Browne inventory tip site, and the concepts
were helpful, but then it launched into a bunch of code without explaining
where it goes or whether it should be typed in exactly that way. Please help!
I'll be happy to provide more info as needed.
Thanks!
materials used during a work order, however, I am not sure exactly how to do
this. I already have tables set up with relationships to accomodate incoming
purchases modeled on the Northwind example, but should I set up a seperate
set of tables for materials used, or can I modify my existing tables to track
both purchases and usage? I'm pretty sure I will need to use a subform on my
work order form to show the parts used, but I am not positive how to set up
the tables. I visited the Allen Browne inventory tip site, and the concepts
were helpful, but then it launched into a bunch of code without explaining
where it goes or whether it should be typed in exactly that way. Please help!
I'll be happy to provide more info as needed.
Thanks!