[mso] Re: ACCESS - Update Records

I guess outside of Dian's method, and your method, Pete, maybe we can look at 
this in another way...

Maybe this way would be easier...

While entering a record, can I have a field do some sort of lookup into another 
table, say, based on data in one field, it would return related data in ANOTHER 
field? Like, if I entered "10034" in the ZIPCODE field, the CITY and STATE 
field would automatically return "NEW YORK, NY". So, in effect, it would just 
enter the data, not really relate it to another record in another table. And, 
overall, the lookup is done while entering the data, so changing data later on 
wouldn't affect the order entered... know what I mean?

---Charlie

  ----- Original Message ----- 
  From: Peter Chiavaro 
  To: mso@xxxxxxxxxxxxx 
  Sent: Wednesday, May 22, 2002 3:09 PM
  Subject: [mso] Re: ACCESS - Update Records



  Cousin Charlie,

    Don't you have a table for your Items / products?

  In your Items (or whatever you're selling) table, you need to have stuff =
  like this:

  "everything the Item CAN HAVE ONLY ONE OF"

  An Item can have only ONE:
  ItemID
  Description
  Location (in your stock room)
  OH_QTY (on hand quantity)
  WARN_QTY (Quantity you MUST ALWAYS keep in the house)
  Weight
  Size
  And of course "Price".
  And of course,,, anything ELSE you can think of that an Item CAN ONLY =
  HAVE ONE OF.

  *NOTE that an Item CAN have a Unit_Price, Case_Price, Skid_Price,

  But that don't matter, these prices STILL go in this table, Because.

  An Item can have only ONE:
  Unit_Price
  Case_Price
  Skid_Price

  You would NOT put something like SupplierID in the Items table because =
  an Item can have MANY suppliers.

  Get the Idea?

  Peter C.
  Stuart, Florida
  ? Kp@xxxxxxxx
  -_-_-_-_-_-_-_-_-
  ICQ =3D 412633



  So,, you need to keep the "Price" in this table and if the price =
  changes, sorry Paissano, but you'll have to open the Items table, go to =
  the Item and change the price.

  Where (in what table) and WHY are you trying to change prices? Maybe I =
  missed something.

  Peter C.
  Stuart, Florida
  ? Kp@xxxxxxxx
  -_-_-_-_-_-_-_-_-
  ICQ =3D 412633



  -----Original Message-----
  From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On =
  Behalf Of Charles Ippolito
  Sent: Wednesday, May 22, 2002 12:37 PM
  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.=20

      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.
      *************************************************************

    *************************************************************
    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.
    *************************************************************

  *************************************************************
  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.
  *************************************************************=20

  *************************************************************
  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: