Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Camp Lejeune, North Carolina, USA
    Thanked 0 Times in 0 Posts

    Access 2000 (9.06926 SP3)

    In my database I have a patient information table which lists patient Command by abbreviations. I have a Command Table which is used for Spelling out these Commands for Letters, etc. One of the commands has changed from "Force Service Support Group" to "Marine Logistic Groups". The abbreviated name would change from FSSG to MLG.

    I need this change to reflect in all queries, tables, reports.

    Is there an easy way to change all FSSG to read MLG in tables, and Force Service Support Group to Marine Logistic Groups.

    Probably really simple and that is why it seems so hard to me.

    Thank you

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Access 2000 (9.06926 SP3)

    If you have relationships between the Command table and the other tables that contain command abbreviations, and set Referential Integrity with Cascading Updates, you only need to change the abbreviation and command in the Command table. The abbreviations in the other tables will be updated automatically.

    If you have already changed the abbreviation in the Command table, but don't have the relationships as described above, change the abbreviation back to FSSG. Then create the relationships, set their properties (double click the lines between the tables in the Relationships window). Finally change FSSG to MLG again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts