Hi TC,
Thanks for responding. These are the affected tables complete with all
their fields, though they are not all within the query which produces my
faulty form. The query is named Qry_THA3 and the form produced is frm_THA2:
subProcedure Tag: Procedure Tag (PK), Procedure Name, Procedure.
Tbl_THA: THA_number (PK), Procedure Tag (indexed, no duplicates), Date,
Area_Description, Assess_Performer, Physical_Hazards, Biological_Hazards,
Chemical_Hazards, Work_Other_Hazards, design, guards, Comm, isolation,
ventilation, automation, barriers, Other9a, Other9b, substitution, training,
Safe_Plan, Policy, Other10a, Other10b, Hard_hat, Eyewear, Safe_feet,
Respirator, Fall_protect, hearing, Vest, Coveralls Gloves, Other 11a, Other
11b, Hazard1 (there are 16 Hazard* fields).
Tbl_PhysHaz: Physical_Hazard _# (PK), Procedure Tag (indexed,no
duplicates), Lift_handle, Repetitive, Slip_trip, Moving_parts, Work_heights,
Pressure_sys, Vehicle, Electricity, Noise, Lighting, Vibration, Other1a,
Other1b, Other2a, Other2b, Lift_handle#, Repetitive#, Slip_trip#,
Moving_parts#, Work_heights#, Pressure_sys#, Vehicle#, Electricity#, Noise#,
Lighting#, Vibration#, Other1a#, Other1b, Other2a#, Other2b.
Tbl_BioHaz: Bio_Hazard# (PK), Procedure Tag (indexed,no duplicates), Mould,
Blood_fluid, Sewage, Other3a, Other3b, Other4a, Other4b, Mould#,
Blood_fluid#, Sewage#, Other3a#, Other4a#.
Tbl_ChemHaz: Chem_Hazard# (PK), Procedure Tag (indexed,no duplicates),
Compress_gas, Flame_combust, Oxidize, Toxic, Infect, Corrosive, Mist_vapour,
Dust, Other5a, Other5b, Other6a, Other6b, Compress_gas#, Flame_combust#,
Oxidize#, Toxic#, Infect#, Corrosive#, Mist_vapour#, Dust#, Other5a#,
Other6a#.
Tbl_Work/OtherHaz: Other_Hazards_# (PK), Procedure Tag (indexed,no
duplicates), Confined, Temp, Other7a, Other7b, Violence, Alone, Lights,
Other8a, Other8b, Confined#, Temp#, Other7a#, Violence#, Alone#, Lights#,
Other8a#.
Tbl_HazRating: Hazard_Rating_# (PK), Procedure Tag (indexed,no duplicates);
there are 16 each of the following fields: Haz_Decsrip*, Exposure* ,
Probability*, Conseq*, Total*, Rating*a, Rating*b, Rating*c.
In Qry_THA3, the primary key fields of each table are not involved in the
query but all the other fields are. The only exception is Procedure Tag from
subProcedure Tag table, which is the only field used from that table in the
query, and it links all the other tables together.
I hope that this information is comprehensive enough, if not let me know
what else is needed.
Thanks for the help,
J@50N-5ALTR