i have a old database accdb file with relationship between tables. I need to add a new table between two table but i am worried that may effect the front end since the query are designed on old relationship. Do i need to redesign each and every query . that is lots of work. is their a simple way to do it.