Scheduling relationship structure

[MarkWilson]

I am working on a scheduling module for our production shop.  I want to display the Work Orders in a list and Schedule time to each of the Stations between the Work Order IssueDate and ShipDate.

 

 

Secondly, I would like to report back the actual hours spent vs. the Scheduled time for progress reporting.

 

 

Tables:

 

Work Order  (500/year)

WorkOrder#

Description

IssueDate

ShipDate

 

Stations  (7-10)

StationID

StationName

 

Schedule  (1 for each Work Order)

WorkOrder#

StationID

TimeEstimated

 

TimeTracking (1000s/year)

EmployeeID

EmployeeName

WorkOrder#

DateWorked

TimeWorked

 

Employees (20+)

EmployeeID

EmployeeName

 

 

Thank you for your guidance.

 

Mark

 

 

[MarkWilson]

WorkOrder::_pk_WorkOrder -->  X  --> Stations::_fk_WorkOrder.  (or a constant key with =)  Allows all the records in the Stations TO to be accessed by any and all of the records in the WorkOrder TO.

Stations::_fk_Schedule -->  =  --> Schedule::_pk_Schedule.  Allows related data be added to the Schedule table via the Stations portal on the WorkOrder TO.

How can the WorkOrder::_pk_WorkOrder value pass to the Schedule::_fk_WorkOrder field?