[mso] Re: Access Relationships :VSMail MX1
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 6 Aug 2002 09:51:36 -0700
Peggy,
You should be fine deleting the extra instances of the table.
James
-----Original Message-----
From: Wier, Peggy J. M. [mailto:pjmwier@xxxxxxxxxx]
Sent: Tuesday, August 06, 2002 9:45 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access Relationships :VSMail MX1
In the relationships window, I tried several times to create a relationship
between two tables by dragging the primary key in one table on the foreign
key in the other table and enforcing referential integrity. Each time I
closed the relationships window I selected "yes" to save my relationships.
When I opened the relationships window again the relationship did not seem
to take: that is, the relationship line was not there between the two
tables.
I tried restarting Access.
I tried restarting my machine.
Still had the same problem.
So based on an earlier experience, I created a new database and imported
everything from the old.
I went into the relationships window and it shows the one (primary key)
table SEVEN times with a relationship between each one and the table with
the foreign key.
Does anyone have any ideas? Can I delete the other six relationships and
tables be okay? Or do I need to create yet another new database?
Peggy J. M. Wier
TRAX Training & Documentation Specialist
pjmwier@xxxxxxxxxx
Purdue University
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
