GTC-KTX
asked on
Microsoft Database table relationship question
I have the tables and relationships shown in the attached screenshot.
I simply want to replace the "Opportunities" table with the "keystoneopportunities" table.
I want all the new relationships to match how they were for the "Opportunities" table.
I'm new to MS Access and i'm having trouble doing this.
Hoping someone can walk me through this. I have Access 2007.
DB-relationship.gif
I simply want to replace the "Opportunities" table with the "keystoneopportunities" table.
I want all the new relationships to match how they were for the "Opportunities" table.
I'm new to MS Access and i'm having trouble doing this.
Hoping someone can walk me through this. I have Access 2007.
DB-relationship.gif
ASKER
The new table has many additional fields. Will renaming it still work in that case?
if you are not certain of what you are doing, Create a backup copy of your DB
in the Realationship,
create the same relationship of the tables Customers, Employees, and DocAttachments to table keystoneopportunities",
when done, delete the table Opportunities
in the Realationship,
create the same relationship of the tables Customers, Employees, and DocAttachments to table keystoneopportunities",
when done, delete the table Opportunities
renaming the table will break the relationship
ASKER
so i rename the table "opportunity to something else, just to break the relationships it has.
then i establish those same relationships with the KeystoneOpportunities table.
I know its propbably a stupid question, but i don't know how to rename the table.
Also, to establish those same relationships with the new table, i assume that i go to the database tools tab, and then choose relationships. But this choice is grey'd out (wont let me pick it). Any suggestions?
then i establish those same relationships with the KeystoneOpportunities table.
I know its propbably a stupid question, but i don't know how to rename the table.
Also, to establish those same relationships with the new table, i assume that i go to the database tools tab, and then choose relationships. But this choice is grey'd out (wont let me pick it). Any suggestions?
you have to select Tables from the Navigation pane.. then click on the relationship icon
how did you get the image of the relationship posted above?
how did you get the image of the relationship posted above?
did you see my comment at http:#a24060307
ASKER
Thanks for the post capricorn.....yes i did see your comment, and admittedly i'm struggling with this a bit.
I'm not sure why the relationship option was initially grey'd out, but i have it open now. So i now have the same view that i posted in the image. I see from your post that i have to break the relationships to the opportunities DB. You say that renaming will break the relationship. I'm having trouble figuring out how to rename. I also seem to have added a relationship from my keystoneopportunities to the customer table, but it doesn't have the "one to many" designation (i think thats what it is). I attached another screenshot.
DBrelationship3.gif
I'm not sure why the relationship option was initially grey'd out, but i have it open now. So i now have the same view that i posted in the image. I see from your post that i have to break the relationships to the opportunities DB. You say that renaming will break the relationship. I'm having trouble figuring out how to rename. I also seem to have added a relationship from my keystoneopportunities to the customer table, but it doesn't have the "one to many" designation (i think thats what it is). I attached another screenshot.
DBrelationship3.gif
double click on the link (the line that connects the table) that you created to edit the relationship.
ASKER
i can get there to edit this new relationship.
There are 3 choices for join type.
1. only incl rows where joined fileds from both are equal.
2. Incl ALL records from 'Customers' and only those records from 'Keystoneopportunities' where joined fields are equal.
3. Include ALL records from 'Keystoneopportunities' and only those records from 'Customers' where the joined fileds are equal.
would it be the 3rd choice?
Also, can you help me rename the Opportunities table so i can break the relationships to that table?
I thought i'd be able to find a place to rename it in the properties, but can't seem to find a place to do that.
There are 3 choices for join type.
1. only incl rows where joined fileds from both are equal.
2. Incl ALL records from 'Customers' and only those records from 'Keystoneopportunities' where joined fields are equal.
3. Include ALL records from 'Keystoneopportunities' and only those records from 'Customers' where the joined fileds are equal.
would it be the 3rd choice?
Also, can you help me rename the Opportunities table so i can break the relationships to that table?
I thought i'd be able to find a place to rename it in the properties, but can't seem to find a place to do that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
GTC-KTX,,
I don't think you are viewing the table Relationship of your database.
If i am not mistaken you are looking at a Query designer window
ASKER
OK. I think i have all the relationships the same. The only thing i'm not sure about is that i don't have the sideways 8 symbol (the many symbol?) on my new relationships, even though the settings appear to be the same. I've attached another screen shot.
relationship4.gif
relationship4.gif
please read my last post..
ASKER
I did readit and i checked. It says "Relationships" for the tab that i am on. Also, I hit "Edit Relationships" on the design tab to establish these new links. I then hit "creat new", and then edited the "join type"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes, Mike is right, just checked it.
ASKER
thanks guys. appreciate the help.
Rename the exsiting table if you feel it is necessary. Based on what we can see the fields are the same.