Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Adding New Table To Existing Database

Discussion in 'Information Technology' started by Junior, Jul 28, 2006.

  1. Junior

    Junior
    Expand Collapse
    Guest

    Good afternoon!!
    I would like someone to validate what I have done. Here is it:

    I am working in an existing database. I have a particular table, let's
    call it [POTRL] which captures infomation pertaining to purcahse orders
    issued by our company. I am not permitted to edit this table in any
    way, because it is part of a VBA software application.

    I need to capture some additional information - so what I did was
    create a new table called [POCUST] (I checked with the vendor of the
    software package, and this is acceptable) into which I will enter data
    in the new fields. What I did was created the new table, with a
    primary key field matching that to the [POTRL] table. I have to
    somehow dump in the data from [POTRL] table into [POCUST], so that I
    can establish a relationship between the two tables, build a query and
    finally construct a form for data entry.

    The way I dumped in the data into [POCUST] is via unmatched query, then
    an append query which populates [POCUST] with all the data I want from
    [POTRL]. So essentially what I have is a new table with all the data
    from the "untouchable" table, plus a few extra custom fields that I
    have created. Everything works fine!

    I built the query, and the form for data entry. In the form's OnOpen
    event, I run the macro which populates the [POCUST] table - so when the
    form loads, I have the most updated information to begin data entry.

    I can finally make additional data entries to populate these newly
    created fields.

    This is the first time I ever had to do something like this. Does my
    logic make sense?? Is there another way to ahive the same result??
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    "Junior" <gziotek@hotmail.com> wrote in message
    news:1151001332.171419.26570@b68g2000cwa.googlegroups.com...
    > Good afternoon!!
    > I would like someone to validate what I have done. Here is it:


    The reason for doing it should be validated first. If you are doing the
    wrong thing for the wrong reason, then there isn't much point to validating
    the steps you took to do it.

    --
    Phillip Windell [MCP, MVP, CCNA]
    www.wandtv.com
     

Share This Page