All sorts of relationships in relationship window

[Simon22]

Hi all!
I had a nice relationships table with all my relationships defined between the main entities. However, after a whole bunch of designing of forms and adding features, my relationships window has become cluttered with a load of relationships that I do not recognize. Some are names of my tables with a number after (ex: Clients1) and some just don't seem to need to be there. Do lookup wizards create little relationships? Can I delete all these extra relationships to unclutter my relationship window or will that mess up how my db functions? Thanks!!

 

[montrose]

As you design queries and forms, Access automatically 'links' these additional tables in your db. If you see "Clients1", it is just another instance of your "Clients" table that you've used in your queries. Do not delete them. If you want to "unclutter" and see just the 'direct' relationships that you have, you can view those in your relationship window by clicking on the SHOW DIRECT RELATIONSHIPS button on your tool-bar (it shows just three small tables on the button), and is next to the SHOW ALL RELATIONSHIPS button with multiple small tables on the button. HTH Learn what you can and share what you know.