Bring down record #

I have three tables:

• Work Orders
• Jobs
• Notes

I have the following relationships established between them:
Work Orders < Jobs
Work Orders < Notes
Jobs < Notes

The notes table is embedded in both the Jobs & Work Orders forms.

When I input a note into the Notes table, embedded in the Work Orders form, it works as expected.
It captures the Work Order record number and all of the other pertinent data points.

However, when I input a note into the Notes table, embedded in the Jobs form, it captures everything except the related Work Order record number.

The Job is related to a Work Order, and I need that work order record number to be brought down to the note being input into the job form (via the embedded notes table in the job form).

Both the Work Order and Job are saved, and thus a recorded number is generated, prior to the note being input.

Any thoughts, ideas, suggestions?

------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------