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?