I have designed a database but need help to find the code to link data by
date/time as follows
Times data entered at different parts of the process (Network)
Product 1 Start Date/Time
Product 2 Start Date/Time
Product 3 Start Date/Time
End Line Start Date/Time
---------------------------------------------------
What is needed is to be able to link and report/list all the products that
were run product 1,2,3 date/times
between End line final End Date/Time for each order.
Eg
Start Time product 1 = 12/12/04 8.00 am
Start Time product 2 = 12/12/04 8.15 am
Start Time product 2 = 12/12/04 8.20 am
Start Time product 3 = 12/12/04 8.50 am
Start Time product 3 = 12/12/04 9.10 am
Start Time product 3 = 12/12/04 10.20 am
Order Number 8888
End Line Start 12/12/04 9.00am ( Roll 1 )
End Line Start 12/12/04 9.30am ( Roll 2)
End Line Start 12/12/04 10.00am ( Roll 3 )
End Line Start 12/12/04 10.30am ( Roll 4 )
Order Number 9999
End Line Start 12/12/04 10.30am ( Roll 1 )
What is needed is now to link all the product 1,2,3 data by Date/Time
between the End Line Start/Finish Date/Time to order number.
Order numbers are not possible to be assigned to Start Time product 1,2,3 as
these ingrediants could be in several orders.
Hope someone can help ??
Many thanks
Robin