changes to inventry control template

[daveyboy300]

hi all can someone please help,

i am using the above template. I have created a unit cost field in the
products table i just need to know how i can get access to automaticlly enter
this cost into the inventry transactions table when i select the product
required.

iam am sure it is quite simple to do but just can't see how i do it

ie: the product has a standard cost and wont change

many thanks in advanced

Dave

 

[Mike Painter]

hi all can someone please help,

i am using the above template. I have created a unit cost field in
the products table i just need to know how i can get access to
automaticlly enter this cost into the inventry transactions table
when i select the product required.

iam am sure it is quite simple to do but just can't see how i do it

ie: the product has a standard cost and wont change

many thanks in advanced

I assume you know storing values like this is rarely a good idea?
It can be justified here if your prices change frequently.


Once done you will have to modify *all* queries, reports and other forms to
reflect this action.

It can be done in several ways but probably the easist is to make sure the
form is based on a query relating the inventory items with the products
tables

Me!ProductsCostField = Me!InventoryCostField in the after update event will
work.