[mso] Re: ACCESS - Update Records

  • From: James LaBorde <jlaborde@xxxxxxxxx>
  • To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
  • Date: Tue, 21 May 2002 11:17:14 -0700

Charlie,

Are you saying that you want to change data that is linked but not have it
changed everywhere it has already been entered?  It sounds like you may be
trying to violate referential integrity which isn't necessarily a good idea.
If you do want to do it, you can simply uncheck the box to enforce
referential integrity on the relationships.  Be very careful with doing this
though.  It will allow you to have "orphaned" records in your database.  

James La Borde
South Western Federal Credit Union

-----Original Message-----
From: Charles Ippolito [mailto:CharlesMTFAccess@xxxxxxxxxxx]
Sent: Tuesday, May 21, 2002 11:01 AM
To: MSO
Subject: [mso] ACCESS - Update Records :VSMail MX2


I have my tables and forms set up. I have my relationships between all the
tables set up as well. Now, using a form, when I enter data in one field, it
will automatically add the correct info in related fields. Fine, as that's
what I want.

However, sometimes I might change data in a field from a table and I do NOT
want it to update in existing records... how would I go about doing this?

If I didn't explain that correctly, let me know and I'll rephrase my
request.

Thanks!

---Charlie



*************************************************************
PLEASE READ!!!!

You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes).  Do not
put unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the
caps prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.

http://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.
*************************************************************
*************************************************************
PLEASE READ!!!!

You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

http://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.
*************************************************************

Other related posts: