i'm a bit confused because this form will now be based on 5 tables. Would i be right in saying that i should base the main form on tblStaff and then use 4 subforms to get the data into the other tables ?
There are a couple of ways you could approach it, depending on how you want to view/enter the data. You could have a main form based on tblStaff, with a sub form based on tblTrainingRecords. This sub form would likely have a sub form of it's own based on tblTrainedSOPData. The other two tables (tblJobs and tblSOPList) would not be directly involved here. They would simply provide the data for combo boxes. With this form you would select a Staff member, and then view/enter the Training related to that Staff member.
Or, you could have a main form based on tblJobs, with a sub form based on tblTrainingRecords. Again, this sub form would have a sub form of it's own based on tblTrainedSOPData. With this form you would select a Job, and then view/enter the Staff members that have been/are being trained for that Job.