Richard your WorkOrder System is a perfect start solution for my Son who owns a Marine Related Business specialising in Boat Sales, Servicing and Maintenance. You were also correct in recommending I buy the Seminar to learn techniques otherwise not obvious or even necessarily visible.

My son uses an On-Line Product to save/share Audits done on Boats which also include images of the respective Audit Item. This can then be sent to a Client for their approval of ALL or specific Work/Maintenance/Repairs to be carried out. I have attached a sample Downloaded Audit carried out in December for your reference.

My Question is how would you suggest I go about incorporating this Audit into the WorkOrder System along with all the other Work Orders generated through normal Day to Day Preventative Maintenance, Repairs etc. I can download the Audit CSV into Excel and then Import into Access but I do have to perform some editing such as re linking the images in the Worksheet to reference a Specific SubFolder for each Boat named "Images".

I have currently Created an AuditT Table (AuditID, CustomerID, BoatID, CurrentStatus, Date, Reference) and AuditBoatNameT Table (ID, Item, Title, Assignee, Comments, ImagePath (Hyperlink), DueDate, Completed) for initial testing purposes.

In Addition I would quite like to Automate the Audit Import Process from within Access itself. This is a copy of some of the Data contained in an Audit produced from the Online App "Site Audit Pro" which I wish to Auotomate the import to Access.

Details

1PROJECT INFO
2TitleSuper Air Nautique G23
3Date2023/12/10, 12:02:33
4RefSeatrail and full systems check
5
6
7ClientScotland Nautique
8Address
9CompanyCombines Marine Mallorca
10
11AuditorSimon Chapell
12
13Project CompleteFALSE
14
15
16
17
18
19
20OrderItemTitleAssigneeCommentsImage PathTimestampDue DateCompleted
2101Mooring In Marina Botafoc2024/01/29, 16:34:4931/01/2024undefined
2210.001    MimFF1iU8tM1wnuuNoDs_image_photo_zRp2lWWB7XU2mb7nG49t.jpeg2023/12/10, 08:34:00
2312 Damage To Soft Deck2024/01/29, 16:34:4931/01/2024undefined
2420.001    xtFB5XHmW1gOeaGB7dNR_image_photo_q0XgbPjdHYTJAUpgRRrz.jpeg2023/12/10, 09:31:06
2523 Covers Ripper2024/01/29, 16:34:4931/01/2024undefined
2630.001    cdlD0jEavWjXqxg3v3uT_image_photo_kWVvJ5a4ILJHBMES2w2s.jpeg2023/12/10, 09:31:40
2734 Damage To Soft Deck Stbd Side2024/01/29, 16:34:4931/01/2024undefined
2840.001    lS8wYuzE4xXrC2oSPwci_image_photo_5sgrQAqFz3aFd7IH7GW0.jpeg2023/12/10, 09:31:50
2945 Hinge Cover Missing2024/01/29, 16:34:4931/01/2024undefined
3050.001    k1UKnhLAV5dK8tInbRPg_image_photo_iOe99ElLmlCxORElssab.jpeg2023/12/10, 09:32:22
3156Paint To Tower Blistered2024/01/29, 16:34:4931/01/2024undefined
3260.001    PCaotWAnOQo224UG6dZe_image_photo_s0pIM4D6nnkS74id6dTM.jpeg2023/12/10, 09:40:39
3367 As Above2024/01/29, 16:34:4931/01/2024undefined
3470.001    vp6725FUoGjuAB70KGDC_image_photo_yJk0ljIZtAIDeO4vFCKT.jpeg2023/12/10, 09:40:40
3578  As Above2024/01/29, 16:34:4931/01/2024undefined
3680.001    7wjfgqHuJzxlJRBBy2gL_image_photo_tCQxOyP0J5sfJ3xAAMMw.jpeg2023/12/10, 09:40:43
3789  As Above2024/01/29, 16:34:4931/01/2024undefined
3890.001    bEELBuCiTAQLkkCkBdEe_image_photo_WWEkGzGbXW2r3KQABBjX.jpeg2023/12/10, 09:40:44
39910 Steering Wheel Torn2024/01/29, 16:34:4931/01/2024undefined
40100.001    MWOWhEAE3MMY8mVTMppY_image_photo_XZfo9R5FASNaY9AdJOhV.jpeg2023/12/10, 09:42:07