Tried to find this in a search.
Every time I modify a table it adds the new table to the relationship view. At this point, while I only have 4 main tables and 8 look up tables, with all the modifications I made, I can no longer see the original relationships.
Is there any way to set Access so that any table modification that is saved, replaces, not adds a table icon, in the relationship view?
Short of that, is there anyway I can just view the basic realtionship? i.e. just show one table and it's relationship to the 12 tables in my database.
Thanks
k
Every time I modify a table it adds the new table to the relationship view. At this point, while I only have 4 main tables and 8 look up tables, with all the modifications I made, I can no longer see the original relationships.
Is there any way to set Access so that any table modification that is saved, replaces, not adds a table icon, in the relationship view?
Short of that, is there anyway I can just view the basic realtionship? i.e. just show one table and it's relationship to the 12 tables in my database.
Thanks
k
