First, if you cant update due to Relationship Integrity, you must add data by grouping it first, and;
What is your Foreign Key and Primary Key in Inventory Transactions table?..
Does the Value from rs("part") is a Foreign key and Does the Value you are adding is existing to its Primary Table?..
Does rs("transaction type") is a Foreign key also has a reference Table?..
Does rs("Technician") is a Foreign key also has a reference table?..