copying a field automatically from another field

[scottappleford]

Hi

Forgive me - but i am new to db.

I have an employee field in my purchase orders from and when I do stock transactions - i have an employee field against each item in the purchase order. I would like to just copy the employee field from the purchase order form automatically next to each product listed instead of having to keep typing the same thing.

the reason i am doing this is because when people come to take stock out - i would like to see there name against each item in the products from so people can not not take more than they ordered.

thanks in advance.

 

[ColinEssex]

If your db is on a network you can use the

Environ("UserName")

to pick up the network name and post that to the field.

Col

 

[pafcpilgrim]

Trying not to get too complicated but if you have an employee master form you can put the orders form in as a subform and link the two Employee ID fields together you can do this useing the sub form wizzard easily enough.

Once an employee loads up his details on the master form and adds any information to the orders form it will automatically insert their ID so that the records relate to each other.

also every time that employee open up their details any records in the purchase orders sub form with their id attached will show up.

If you need anything else just ask.

Mike

 

[scottappleford]

can i not use a bit of code e.g. on exit update the required field?

I have an employee table - the thing is the person entering the data is usually not the person who ordered it, which is what i need, the person who ordered it.

In the main purchase order form there is an emploee id to show who instigated the order. then in the subform (inventory transaction) they pick the product the project and then employee id (which i do not really need here) but i need it for elsewhere. not if the employee id could automaticaly update in the sub form then that would be great.

when you view the actual products on a seperate it splits the purchase orders to show for each product e.g. 10 nr purchase order with say 20 differernt products in each - then shows (on a seperate form the products form) as what number that purchase order it realates to, then also the number ordered etc and the emplyee id, which comes from the sub form in pruchase orders. now the reason for this is many people could order the same product for that same project (for different reasons). i then have another subform on the products page of that item going in and out of stock.

for the employee id on the products form means it can be seen if someone is asking for more stuff then they ordered (which happens).

thanks again

scott

 

[scottappleford]

explained better

can i not use a bit of code e.g. on exit update the required field?

I have an employee table - the thing is the person entering the data is usually not the person who ordered it, which is what i need, the person who ordered it.

In the main purchase order form there is an emploee id to show who instigated the order. then in the subform (inventory transaction) they pick the product the project and then employee id (which i do not really need here) but i need it for elsewhere. not if the employee id could automaticaly update in the sub form then that would be great.

when you view the actual products on a seperate it splits the purchase orders to show for each product e.g. 10 nr purchase order with say 20 differernt products in each - then shows (on a seperate form the products form) as what number that purchase order it realates to, then also the number ordered etc and the emplyee id, which comes from the sub form in pruchase orders. now the reason for this is many people could order the same product for that same project (for different reasons). i then have another subform on the products page of that item going in and out of stock.

for the employee id on the products form means it can be seen if someone is asking for more stuff then they ordered (which happens).

thanks again

scott