Table Relationships

[Turk Ries]

I think that I understand the point in table relationships, but I'm not sure
if I'm on the right path.

When I add a new record in a table, how can I make it automatically change a
field in another table?

Example:

I have a table of molds and a table of orders.

When I add an order, it affects the status of a mold. When I add an order in
my order table I want to put in a mold status change that will also change
the mold table. That way, the next time I use that mold, I'll see the latest
status.

Thank you.

 

[John W. Vinson]

I think that I understand the point in table relationships, but I'm not sure
if I'm on the right path.

When I add a new record in a table, how can I make it automatically change a
field in another table?

You wouldn't, you shouldn't, and you needn't.

Example:

I have a table of molds and a table of orders.

When I add an order, it affects the status of a mold. When I add an order in
my order table I want to put in a mold status change that will also change
the mold table. That way, the next time I use that mold, I'll see the latest
status.

If the Status can be calculated from the presence or absence of a record in
the Order table, just use a query which calculates it when needed.

 

[Turk Ries]

How?

A status will always be present. It will always show one of these 4 things:
Bring In, Take Out, Cover or In Maintenance.

The "Order Table" contains the following columns: Model #, Mold #, Mold
Status. The "Mold Table" contains the same.

On my form, I have a combo box that shows me the mold info from the "Mold
Table". When I select the Model # from the combo box, it fills in the model
#, mold # and mold status fields of a new record in my "Order Table".
However the status field will need to be changed and when I change it on the
form, I want it to change the last entry in the "Mold Table".

I hope this makes sense.

Thank you.