Welcome to SPN

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

Sign Up Now!

Union Query

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

Tags:
  1. Secret Squirrel

    Secret Squirrel
    Expand Collapse
    Guest

    I have a union query that is pulling data from 2 tables. The fields are the
    same in each table but they are different locations. There is one field that
    I am pulling that is a "Yes/No" field. When I open my form that runs the
    query I want to be able to put a check in that "Yes/No" field. When I try it
    I get a message that says the record is not updateable. Any idea if this can
    be done through a union query or am I missing something?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikh Union Make Special Visit To Houses Of Parliament To Showcase Their Community Work - Breaking News Jul 30, 2016
    Heritage India's Union Sports Ministry To Promote Gatka History of Sikhism Oct 23, 2013
    Hi-Tech Unites the World's Sikhs in Daily Communion Sikh Sikhi Sikhism Jun 29, 2013
    The Holy Union of Anand Karaj New to Sikhism Mar 16, 2013
    General Union with God (BoKSD 6) Hard Talk Dec 4, 2012

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    I don't believe you can through a Union query. My question is why you have
    two tables? Why not just add a "location" field to the records and put them
    all in one table? That would be much more normalized.

    If you do so, the data will be easier to work with and your queries would be
    updatable.

    You can still limit access to the data by location using the new location
    field and filtering the data appropriately.

    Most of the time (but NOT always) when you find yourself using Union
    queries, you are likely to have a normalization issue.

    --
    Rick B



    "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    message news:918C9E8D-C8E4-4E2F-9EB0-AAC971934B75@microsoft.com...
    >I have a union query that is pulling data from 2 tables. The fields are the
    > same in each table but they are different locations. There is one field
    > that
    > I am pulling that is a "Yes/No" field. When I open my form that runs the
    > query I want to be able to put a check in that "Yes/No" field. When I try
    > it
    > I get a message that says the record is not updateable. Any idea if this
    > can
    > be done through a union query or am I missing something?
     
  4. Secret Squirrel

    Secret Squirrel
    Expand Collapse
    Guest

    Well I have to keep them in different tables because they generate different
    ID's for each plant. I agree putting them in the same table would be easier
    but because of the ID #'s they have to be separate. So how can I link these
    two tables in a query and be able to update fields from one form? Is there
    another way around the Union Query?

    "Rick B" wrote:

    > I don't believe you can through a Union query. My question is why you have
    > two tables? Why not just add a "location" field to the records and put them
    > all in one table? That would be much more normalized.
    >
    > If you do so, the data will be easier to work with and your queries would be
    > updatable.
    >
    > You can still limit access to the data by location using the new location
    > field and filtering the data appropriately.
    >
    > Most of the time (but NOT always) when you find yourself using Union
    > queries, you are likely to have a normalization issue.
    >
    > --
    > Rick B
    >
    >
    >
    > "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    > message news:918C9E8D-C8E4-4E2F-9EB0-AAC971934B75@microsoft.com...
    > >I have a union query that is pulling data from 2 tables. The fields are the
    > > same in each table but they are different locations. There is one field
    > > that
    > > I am pulling that is a "Yes/No" field. When I open my form that runs the
    > > query I want to be able to put a check in that "Yes/No" field. When I try
    > > it
    > > I get a message that says the record is not updateable. Any idea if this
    > > can
    > > be done through a union query or am I missing something?

    >
    >
    >
     

Share This Page