Results 1 to 3 of 3
  1. #1
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58

    Alter a table design

    Hi All,



    I have a table (TblSales) in my database with some data.
    When I first designed I didn't realize to add DealerName instead of Dealer_FK.
    Now I want to either add DealerName or change the Dealer_FK to DealerName so the tablw would show DealerName instead of the number.

    Any help is greatly appreciated.




    TIA,
    Mismag

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you have the DealerID, then you dont need to add the Name,
    you join the table to the tblDealer table to GET the name.

  3. #3
    mismag is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Location
    California, US
    Posts
    58
    Thanks @ranman256 for the quick response.

    Regards,
    Mismag

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Alter Table Statement
    By jo15765 in forum Modules
    Replies: 5
    Last Post: 03-09-2017, 05:05 PM
  2. Alter Table, YES/NO field
    By gmaster in forum Queries
    Replies: 1
    Last Post: 10-29-2014, 03:25 AM
  3. Trying to get an Alter table to work
    By itm in forum Programming
    Replies: 5
    Last Post: 07-31-2012, 06:32 AM
  4. Alter Table syntax error
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 02-06-2012, 05:43 PM
  5. Alter table Yes/No field
    By Cojack in forum Queries
    Replies: 7
    Last Post: 10-27-2010, 11:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums