1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Copy data table

Discussion in 'Business Applications' started by Smarier, Jan 11, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. Smarier

    Smarier Thread Starter

    Joined:
    Jan 11, 2011
    Messages:
    4
    Hi Guys

    Hi am trying to duplicate the entire content of a table into the same table but adding the prefix "A_" in front of the new data. With this i will have the same data twice but one with the "A-" all in the same table.

    Can any body help me?

    Thanks
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Smarier, welcome to the forum.
    Can I ask why you would want to do this?
     
  3. Smarier

    Smarier Thread Starter

    Joined:
    Jan 11, 2011
    Messages:
    4
    I need to do this because we need to control the inventory of the different shops and the software we are using does not allow us to do so. By add the prefix "A-" in front we can control two diffrent inventory with the same software.

    Thanks for the reply
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    When you say table are you referring to a true database table or are you referring to a table in Excel?

    Rollin
     
  5. Smarier

    Smarier Thread Starter

    Joined:
    Jan 11, 2011
    Messages:
    4
    Access table
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    smarier, you do not need to duplicate the stock to cover 2 shops, you use a Many to Many table that relates the stock to the Shop and contains the Quantity for that shop. ie
    Inventory table
    ID 1 Sugar 1KG Bag
    ID 2 Tea 1KG box

    Shops
    ID 1 shop 1
    ID 2 shop 2

    Linking Table
    Shop ID 1 - Stock ID 1 - Quantity 100
    Shop ID 2 - Stock ID 1 - Quantity 20
    Shop ID 1 - Stock ID 2 -Quantity 25
    Shop ID 2 - Stock ID 2 -Quantity 1
     
  7. Smarier

    Smarier Thread Starter

    Joined:
    Jan 11, 2011
    Messages:
    4
    thanks guys i think i found it
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/974009

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice