J
J@50N-5ALTR
Good day to you all,
I posted this question quite a while ago, and was starting to receive some
help but communication broke down and I am still stumped. Hence the repost.
Here it is:
I have a form composed of a query linking various tables together. The
linking field is -Procedure_Tag- which I have indexed on each table and I
allow duplicates. The form view displays everything how I laid it out, but
when I fill out my first record, I get error 3022, stating:
"The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship."
Each table has its own distinct primary key that is shared by no other
table.
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 in advance,
J@50N-5ALTR
I posted this question quite a while ago, and was starting to receive some
help but communication broke down and I am still stumped. Hence the repost.
Here it is:
I have a form composed of a query linking various tables together. The
linking field is -Procedure_Tag- which I have indexed on each table and I
allow duplicates. The form view displays everything how I laid it out, but
when I fill out my first record, I get error 3022, stating:
"The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship."
Each table has its own distinct primary key that is shared by no other
table.
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 in advance,
J@50N-5ALTR