updating another field from aonther one

[scottappleford]

hi

is it possible to update a field after exit from another one?

i have a purchase order form (main) with employee id. i then have a sub form (datasheet) that can have unlimited products relating to that purchase order. I would like the employee id once entered into the main form to auotmatically update the employee id next to each product in the sub-form (datasheet).

the thing is the products will not get entered until after the main form has been filled out so the products rows in the form will not be created on exit from the main form until they are physically enetered.

I want to do this as on another form (the actual product form) which splits the purchase orders into the products - e.g. product 1 has had orders from 10 different purchase orders and i would like to see which employee ordered to stop them taking for than they ordered.

Ther main product form has a subform (datasheet) taken from the sub form in purchase orders (transactions).

I am new to this so any reply would be appreciated with a newbei reading the reply in mind.

many thanks

 

[pafcpilgrim]

Yes you can but if you are using sub_forms just linking the Master and child fields together will automatically put the ID in for you when ever a new record is created. These are in the properties on the sub forms.

Use the wizzard when adding the sub form and if the Employee_ID fields are the same in both tables it will automatically link them for you. Open the form and you should see the employee id (if one is selected) ready for any entries in the new record on the subform

Hope this helps.

 

[scottappleford]

this helps but still a little unsure

Although I can see the emplyee id in the main form - and in the sub form - i would like the sub form employee id to automatically have the main form employees id in it when i create the record in the sub form?

thanks for your patience!

scott

 

[pafcpilgrim]

If i'm thinking along the same line, if your sub form is a datasheet view and you wish to select a list of Employee ID's then you need to set a lookup in that field in the table properties.

There is another tab where you can get it to look up other values from another table it will act as a combo box when you select the Employee Id Field.

The thing is also if you do this you will get errors as the sub form is linked to the main form, so you would have to remove the linked Mater and Child fields for it to work properly.

Does this help

 

[scottappleford]

tried

so if i link the employee id field in the main form/table with the employee id field in the subform/table this will update the subform for me automatically - when i do this it says intermediate link?

thanks