relationships

S

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
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top