relationships

[Steven]

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

 

[Lynn Trapp]

Are you saving the changes to the Relationship layout when you close it?

 

[Roger Carlson]

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.