Extra relationship
in [Tables]
|
From: guangdew via AccessMonster.com on 13 Feb 2010 03:07 In my database, I have a Suppliers table and a Product table. A main/sub form is made based on these two tables. Supplier_ID is the primary key in Suppliers table, Product table also contain this Supplier_ID field but not as primary key. My problem is that after I setup the relationship, MS Access produces another Supliers_1 table and setup a many to one relationship. I tried to delete it, but MS Access keeps on adding it. Any one has an idea about what's wrong? I tried to attach a screen shot of the relationship but don't know how to do it. I can email it to anyone if you are interested. Guangdew -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1
From: Allen Browne on 13 Feb 2010 05:46 How did you try to delete it? By deleting Supplier_1 from the Relationships window? If so, that's not actually deleting the relationship. What I'd suggest would be this: 1. If these are attached tables (in another Access database), open the back end (the file that actually contains the tables.) If they are not linked tables, you are probably already in the right database. 2. Right-click the *line* joining Suppliers_1 to Product, and choose Delete. Confirm that you want to delete this relationship. 3. Right-click the *line* joining Suppliers to Product, and choose Delete. Confirm you want to delete this one too. 4. Delete the Suppliers_1 table from the Relationships window, and Save. 5. Make sure you have the Name AutoCorrect option turned off. For an explanation of how/why, see: Failures caused by Name Auto-Correct at: http://allenbrowne.com/bug-03.html 6. Compact the database. 7. Open the relationships window. Click the Show All Relationships button. Verify that there is no Suppliers_1 table shown, and no relationship at all between Suppliers and Product. 8. Create the relationship you do want between Suppliers and Product tables. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "guangdew via AccessMonster.com" <u58044(a)uwe> wrote in message news:a38fdca27af9d(a)uwe... > In my database, I have a Suppliers table and a Product table. > > A main/sub form is made based on these two tables. Supplier_ID is the > primary > key in Suppliers table, Product table also contain this Supplier_ID field > but > not as primary key. > > My problem is that after I setup the relationship, MS Access produces > another > Supliers_1 table and setup a many to one relationship. I tried to delete > it, > but MS Access keeps on adding it. > > Any one has an idea about what's wrong? > > I tried to attach a screen shot of the relationship but don't know how to > do > it. I can email it to anyone if you are interested. > > Guangdew
From: guangdew via AccessMonster.com on 13 Feb 2010 10:25 Allen, Thank your for responding to my post. You are right that the problem is caused by Name Autocorrect and also I didn't really delete the relationship, I deleted only the Supplier_1 table. After I deleted the relationship, the Supplier_1 table is gone. Thank you again for your help, Guangdew Allen Browne wrote: >How did you try to delete it? By deleting Supplier_1 from the Relationships >window? If so, that's not actually deleting the relationship. > >What I'd suggest would be this: >1. If these are attached tables (in another Access database), open the back >end (the file that actually contains the tables.) If they are not linked >tables, you are probably already in the right database. > >2. Right-click the *line* joining Suppliers_1 to Product, and choose Delete. >Confirm that you want to delete this relationship. > >3. Right-click the *line* joining Suppliers to Product, and choose Delete. >Confirm you want to delete this one too. > >4. Delete the Suppliers_1 table from the Relationships window, and Save. > >5. Make sure you have the Name AutoCorrect option turned off. For an >explanation of how/why, see: > Failures caused by Name Auto-Correct >at: > http://allenbrowne.com/bug-03.html > >6. Compact the database. > >7. Open the relationships window. >Click the Show All Relationships button. >Verify that there is no Suppliers_1 table shown, and no relationship at all >between Suppliers and Product. > >8. Create the relationship you do want between Suppliers and Product tables. > >> In my database, I have a Suppliers table and a Product table. >> >[quoted text clipped - 17 lines] >> >> Guangdew -- Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: Validating two fields Next: No duplicates wanted in column except for default value... |