Database Relationship Advise
This a basic layout of what my system looks like now. I have Events containing many Equipment lists, containging many line items. Events only has one client and equipment lists can only have one venue. I am wondering if I could eleminate the EQuipment list table and keep all those records in line items for easier duplication etc. I would just cant figure out how to make it so that if I change the venue on one EQ list, it would change all the associated line items to the new venue. OR is what I have better?
For the reasons you stated, i would not change this. You clearly have the need to link data to the group of line items that make up an equipment list. Without that EquipmentList parent record, you'd have to link Venue individually to every line item record.