Well...then I can only assume you'll have to learn some Access VBA???? Cos' I don't know how it would be done any other way. Sorry! Dian Chapman Technical Consultant, Microsoft MVP & TechTrax Editor Tutorial web site: http://www.mousetrax.com TechTrax Ezine: http://www.mousetrax.com/techtrax/ Word MVP support site: http://www.mvps.org/word Microsoft support groups: http://support.microsoft.com -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Charles Ippolito Sent: Wednesday, May 22, 2002 11:37 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: ACCESS - Update Records The whoel thing is I don't want to have to actually enter ANY price... the price should be set when the ordered is entered, and the item is looked up for the price... whatever the price is at that given time, that's what the price should remain. ---Charlie ----- Original Message ----- From: Dian Chapman To: mso@xxxxxxxxxxxxx Sent: Tuesday, May 21, 2002 5:43 PM Subject: [mso] Re: ACCESS - Update Records Create another table with just the prices and link the relationship to the field with prices. Then you can change the prices, but the one set for any order will remain unchanged. Make it a combo box so you can click a drop down to easily find the current price, if there aren't too many or start typing and the current price will usually show up fairly quickly. But it'll also give you the advantage of being able to enter a new price if the current one isn't already in the table. Dian Chapman Technical Consultant, Microsoft MVP & TechTrax Editor Tutorial web site: http://www.mousetrax.com TechTrax Ezine: http://www.mousetrax.com/techtrax/ Word MVP support site: http://www.mvps.org/word Microsoft support groups: http://support.microsoft.com -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Charles Ippolito Sent: Tuesday, May 21, 2002 2:05 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: ACCESS - Update Records Well, yes, that is what I need to do, but it's not with every single field. Maybe with an example you can see why I would want to do that... Let's say I have a table with with orders, and I have another table with products for sale. When entering an order, I will enter in the product ID and through the relationships it will automatically fill in the product description and price. Now, in the future, I may need to change the product ID, for whatever reason, and I would need the product ID to change in all the records its been entered in as well. So, there, its ok for everything to change. On the other hand, let's say the price changes. Well, in the past orders, I need to show what the price was at the time the order was entered, NOT what it is currently. So, if I change the price in the PRODUCTS table, I cannot have the price change in orders that have been entered. So, the question is, how would I allow this in some fields, but not others. Thanks! ---Troth ----- Original Message ----- From: James LaBorde To: 'mso@xxxxxxxxxxxxx' Sent: Tuesday, May 21, 2002 2:17 PM Subject: [mso] Re: ACCESS - Update Records 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. //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. //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. //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. //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. //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. //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. *************************************************************