If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationships
Ok, I tied all my tables together, however, instead of answering edit to one
table as I was changing my one to many relationships, I created a new one. Now I have two of the same table except there is a "1" in the title to the newly created one. I want to delete that particular one, but it won't go away. I tried clicking & deleting like the "help" page told me to, but if I click "show tables" it appears again. What can I do to get rid of it permanently? Thanks in advance for your help. |
#2
|
|||
|
|||
Relationships
Are you using that relations in a query? If so, then edit the query by
deleting the relations and rebuilding it in the query. "Mary A Perez" wrote: Ok, I tied all my tables together, however, instead of answering edit to one table as I was changing my one to many relationships, I created a new one. Now I have two of the same table except there is a "1" in the title to the newly created one. I want to delete that particular one, but it won't go away. I tried clicking & deleting like the "help" page told me to, but if I click "show tables" it appears again. What can I do to get rid of it permanently? Thanks in advance for your help. |
#3
|
|||
|
|||
Relationships
Click on the relationship between table A and Table B_1.. then delete the
table.. it's only an alias anyway, won't hurt anything if it stays.. "Mary A Perez" wrote: Ok, I tied all my tables together, however, instead of answering edit to one table as I was changing my one to many relationships, I created a new one. Now I have two of the same table except there is a "1" in the title to the newly created one. I want to delete that particular one, but it won't go away. I tried clicking & deleting like the "help" page told me to, but if I click "show tables" it appears again. What can I do to get rid of it permanently? Thanks in advance for your help. |
#4
|
|||
|
|||
Relationships
Thanks so much for your help!!!
"TomHinkle" wrote: Click on the relationship between table A and Table B_1.. then delete the table.. it's only an alias anyway, won't hurt anything if it stays.. "Mary A Perez" wrote: Ok, I tied all my tables together, however, instead of answering edit to one table as I was changing my one to many relationships, I created a new one. Now I have two of the same table except there is a "1" in the title to the newly created one. I want to delete that particular one, but it won't go away. I tried clicking & deleting like the "help" page told me to, but if I click "show tables" it appears again. What can I do to get rid of it permanently? Thanks in advance for your help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Relationships window | [email protected] | Database Design | 11 | October 2nd, 2005 06:44 PM |
Confused about one-to-many or many-to-many relationships | CAD Fiend | Database Design | 4 | July 7th, 2005 03:38 PM |
Importing Tables/Missing Relationships | Elena | Running & Setting Up Queries | 1 | May 20th, 2005 12:43 AM |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |