I understand this. But the other is frustrating me so, I wish I understood it. -----Original Message----- From: James LaBorde [mailto:jlaborde@xxxxxxxxx] Sent: Wednesday, August 07, 2002 4:43 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Relationships Peggy, Peter is telling you how to get the relationships to show. It may have been that the option to display all relationships was turned off and that would be the reason they were not showing up when you exited and re-entered the window. By selecting Show All Relationships, it should display them even after you leave and come back James -----Original Message----- From: Wier, Peggy J. M. [mailto:pjmwier@xxxxxxxxxx] Sent: Wednesday, August 07, 2002 2:37 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Relationships :VSMail MX1 Peter, Thanks, but this doesn't really address the problem... Originally I kept establishing relationships. Saving them and closing the window. When I reopened the window the relationship had disappeared. So, following previous advice, I created a new database, importing all the objects from the old. I opened the relationships and SURPRISE the relationships are there multiple times! Its as if when I was trying to get them to stay the first go-around they were recorded and not visible. Now in the second go-around they are there. I've tried several times to get rid of the extra instances as James suggested, but the next time I open the relationships window they return. I have also tried repeatedly to create a new relationship and it is not visible when I re-enter the relationships window. (And yes I save upon every close of the window.) Basically, my question is why don't my relationships hold? (Or, are they "holding" but not viewable?) And/Or Is it going to give me grief down the road? Right now the database is only 1/100th of its intended size. -----Original Message----- From: Peter Chiavaro [mailto:kp@xxxxxxxx] Sent: Wednesday, August 07, 2002 3:38 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Access Relationships Hi Miss Peg, In the relationships window, on the toolbar, there are 2 Icons with like dots on them. (kinda like). Slowly pass your mouse over the Icons and click the one that says "Show ALL Relationships". Then you'll see ALL what's in there.... I don't care if the sky falls. If it's in there, you'll see it. Good luck Peter C. Stuart, Florida ? Kp@xxxxxxxx -_-_-_-_-_-_-_-_- ICQ =3D 412633 -----Original Message----- Do have any idea why I couldn't see them in the first database and now = they show in the second? -----Original Message----- From: James LaBorde [mailto:jlaborde@xxxxxxxxx] Sent: Tuesday, August 06, 2002 11:52 AM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Relationships :VSMail MX1 Peggy, You should be fine deleting the extra instances of the table. James=20 ************************************************************* 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 ************************************************************* ************************************************************* 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 *************************************************************