Updating Table Using Sub Form

[FlabbyRoach]

I am using a sub form on my main form,
The sub form is using fields from one table and I need it to update a field in anther table.
Can someone guide me in the right direction?



Database attached.
Sub Form should update Process_Sheet_T.Operation_Number field.

ProcessSheets4-27-17.zip

Thank You

[orange]

Can someone guide me in the right direction?

Please tell us, with an example if appropriate, WHAT you are trying to do.
Describe specifically WHAT you want to happen.

[FlabbyRoach]

I am using the sub form on the main form to add data to the table.
For instance: The sub form uses two fields - Operation_Number & Operation_ID
When inputting the Operation_ID, the Operation_Number textbox is auto filled with =[Operation_ID].[Column](1)
So when I type "Heat Treat" in the Operation_ID part of the form the operation_Number would bring up "HT".
The table holds the Operation_ID and the Operation_Number along with the primary key of SO_Number from the main form.
The form updates the SO_Number and the Operation_ID but does not update the Operation_Number.
I hope this is enough information.
The db file has all the info.
Thanks

[orange]

For clarity and in hopes of getting focused responses, can you step back and tell us in simple English (as you would tell an 8 year old),
-what is the business in simple terms (no jargon)?
-how does an SO relate to an Operation?

The db may have all the info, but we are looking at the business for which this database may be the answer. That is, what is this business and does the database support the business.

Good luck.

[FlabbyRoach]

OK Then, here you go.
We are a manufacturer of industrial cutting tools called a "broach".
These tools are made to order for each customer.
There are many different kinds of "broaches" which the customer can order.
These broaches are made from scratch using purchase orders from the customer.
These purchase orders are entered into our system as a "Shop Order" (SO) number.
Each SO has a quantity, drawing number, description and a delivery date.
Each SO will have many different processes used to manufacture this particular customer's purchase order.
Each process is described as an "Operation".
Each "Operation" has an "Operation Number" (Operation_Number) and an "Operation Description" (Operation_ID).
We use a Process Sheet to give to the workers out in the shop that will have all the "Operations" to manufacture the purchase order.
My job is to make a database of all the "Operations" and to print out a report of these "Operations" to follow for one "Shop Order" (SO).
So my process sheet looks like this:
Process Sheet.pdf
The old PC that stored all this data has been replaced and the software used to make these sheets does not work in the new windows.
Hence my delving into making a DB.
Does this help?

[orange]

Here is a draft model that may help. Based on your post.
I hope it's helpful.

[FlabbyRoach]

And these are the relationships that I have formed already.



I have all the tables, query's & forms set up.
I have the report almost completed but the Operation numbers do not show up in the table or report.

[orange]

Just got back to this.
So you talk about Purchase Order, but don't really use it.

When I look at your design, I see the standard customer -order --orderDetail-Item sort of template which is very solid.

Customer-->Order-->OrderDetail<---Item

Where do your orderNumbers get assigned? Are you using table lookups in the table fields?
How will you record who does/completes which Operation? Is it necessary?

You do NOT need OperationNumber and OperationID in the ProcessSheet table.
You can get the OperationNumber from the OperationsT via the OperationID (eg use a query)

Do you keep an inventory of Drawings?

Good luck with your project.