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
I am hoping someone can help me, I am trying to create a
relationship in a database and I am having a lot of trouble. I am trying to make is so in my database when I enter information into my assets table, some of the columns get entered into another table in a linked database. What I tried to do is create a relationship between the 2 tables that have common columns. When I create those relationships in the relationship tool, I click on save and exit, however, when I reopen the tool the relationships that I created are not there anymore. I Have tried this numerous times and I am unable to get them to stay after I close the window. Can anyone tell me why this would happen? Thank you in advance. Steven |
#2
|
|||
|
|||
relationships
Are you saving the changes to the Relationship layout when you close it?
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Steven" wrote in message ... I am hoping someone can help me, I am trying to create a relationship in a database and I am having a lot of trouble. I am trying to make is so in my database when I enter information into my assets table, some of the columns get entered into another table in a linked database. What I tried to do is create a relationship between the 2 tables that have common columns. When I create those relationships in the relationship tool, I click on save and exit, however, when I reopen the tool the relationships that I created are not there anymore. I Have tried this numerous times and I am unable to get them to stay after I close the window. Can anyone tell me why this would happen? Thank you in advance. Steven |
#3
|
|||
|
|||
relationships
First of all, creating a relationship will not automatically enter data into
another table. So this is probably not the answer to your problem. You should look at a Form/Subform scenerio. The subform control will automatically enter the primary key of the main form into each record created in the subform. Secondly, you say you want to create a relationship with a table in a separate linked database. You can't create a relationship between tables in separate databases, even if they are linked into a third. In order to create a relationship both tables must be in the same database. Note: When I say relationship, I am talking about one where Referential Integrity is turned ON (that is there is a 1 and infinity symbol on the line). If there is not, it's not really a relationship. -- --Roger Carlson www.rogersaccesslibrary.com Reply to: Roger dot Carlson at Spectrum-Health dot Org "Steven" wrote in message ... I am hoping someone can help me, I am trying to create a relationship in a database and I am having a lot of trouble. I am trying to make is so in my database when I enter information into my assets table, some of the columns get entered into another table in a linked database. What I tried to do is create a relationship between the 2 tables that have common columns. When I create those relationships in the relationship tool, I click on save and exit, however, when I reopen the tool the relationships that I created are not there anymore. I Have tried this numerous times and I am unable to get them to stay after I close the window. Can anyone tell me why this would happen? Thank you in advance. Steven |
Thread Tools | |
Display Modes | |
|
|