OK, good feedback, here goes.
The garage will have many vehicles in the garage.
Each Vehicle can have many WOs (so imagine the vehicle is being MOT'd - that is one WO, the vehicle will be Serviced - that's another WO, the vehicle will be Cleaned - thats another WO) Each WO throughout the garage and will have a unique number (WO1001, etc) Start & End date and a comments section
Each WO will have many jobs to complete (so MOT will need - Oil change, Filter Change, etc)
Each Job will have specific RA (Use of Ventilation, Hand Arm Vibrations, etc), PPE (Boots, Gloves, Overalls, Eye Protection), EQ (Spanner!, Hammer, Wrench, etc) to complete the job
I've normalised the Data into the tables you can see in the attachment.
I want to be able to put this information on to a form (Tab Controlled) and subsequently on to a report (through Subforms) but to have a drop down menu which links to the RA,PPE,EQ tables. At the moment the subform will only allow me to link to the Vehicle Form but it wont provide the Link to the RA tables, I think its because they're too far away.
Does this help, see att.
I know its going to be a simple solution, but ive been battling with this for a while and I cant see the wood for the trees
Any offers !