Welcome to SPN

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

Sign Up Now!

Single record table - other tables using this information

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

  1. Rich J

    Rich J
    Expand Collapse
    Guest

    I have a large database that incorporates various forms. At the beginning of
    the project, initial information is entered in a single record table that
    will never change throughout the course of the project. Such as: Project
    Start Date, Project Expense Code, Contractor, Number of Working Days allowed,
    etc. 19 fields in all that won't change.
    The other forms need access to this data. What I have done is assigned the
    primary key the value ' 1 '. I have a field in every table that is 1 bit in
    size and each form automatically puts a ' 1 ' in the corresponding table for
    each record.
    When a person opens the form they are using all the information is there and
    it works great. Each form is based on a query that takes the information
    from its table and the Project Info table and fills in the corresponding
    text box.
    I can't help but think that there may be a better way to have access to the
    information than repeating this ' 1 ' hundreds of times even though it is a
    tiny size field. Comboboxes would work but seem even more complicated for
    this.
    Thanks for any comments or advice.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Record single day paddy arrival in Punjab (New Kerala) Breaking News Oct 11, 2007
    Canada Racist Anti-immigration flyers single out Sikh community in Brampton Breaking News Apr 25, 2014
    Kirpan - Single edged or Double edged? Questions and Answers Jun 23, 2013
    Seeing Through The "Single Eye" of Equality Interfaith Dialogues Mar 11, 2012
    Poetry Single method is enough...loll Punjab, Punjabi, Punjabiyat Nov 8, 2011

  3. Adam P

    Adam P
    Expand Collapse
    Guest

    If it is a single record in the table, try adding the table to your
    existing query without a join and dragging down the field(s) you need.


    Rich J wrote:
    > I have a large database that incorporates various forms. At the beginning of
    > the project, initial information is entered in a single record table that
    > will never change throughout the course of the project. Such as: Project
    > Start Date, Project Expense Code, Contractor, Number of Working Days allowed,
    > etc. 19 fields in all that won't change.
    > The other forms need access to this data. What I have done is assigned the
    > primary key the value ' 1 '. I have a field in every table that is 1 bit in
    > size and each form automatically puts a ' 1 ' in the corresponding table for
    > each record.
    > When a person opens the form they are using all the information is there and
    > it works great. Each form is based on a query that takes the information
    > from its table and the Project Info table and fills in the corresponding
    > text box.
    > I can't help but think that there may be a better way to have access to the
    > information than repeating this ' 1 ' hundreds of times even though it is a
    > tiny size field. Comboboxes would work but seem even more complicated for
    > this.
    > Thanks for any comments or advice.
     
  4. Rich J

    Rich J
    Expand Collapse
    Guest

    I tried deleting the join between the key field in the Project Info table and
    corresponding field in several tables and got that 'ambiguous outer join'
    error message that wouldn't let the query run. If I reconnect the join the
    query works fine.

    "Adam P" wrote:

    > If it is a single record in the table, try adding the table to your
    > existing query without a join and dragging down the field(s) you need.
    >
    >
    > Rich J wrote:
    > > I have a large database that incorporates various forms. At the beginning of
    > > the project, initial information is entered in a single record table that
    > > will never change throughout the course of the project. Such as: Project
    > > Start Date, Project Expense Code, Contractor, Number of Working Days allowed,
    > > etc. 19 fields in all that won't change.
    > > The other forms need access to this data. What I have done is assigned the
    > > primary key the value ' 1 '. I have a field in every table that is 1 bit in
    > > size and each form automatically puts a ' 1 ' in the corresponding table for
    > > each record.
    > > When a person opens the form they are using all the information is there and
    > > it works great. Each form is based on a query that takes the information
    > > from its table and the Project Info table and fills in the corresponding
    > > text box.
    > > I can't help but think that there may be a better way to have access to the
    > > information than repeating this ' 1 ' hundreds of times even though it is a
    > > tiny size field. Comboboxes would work but seem even more complicated for
    > > this.
    > > Thanks for any comments or advice.

    >
    >
     
  5. Rich J

    Rich J
    Expand Collapse
    Guest

    I am re-posting this question in the Queries section.

    "Rich J" wrote:

    > I have a large database that incorporates various forms. At the beginning of
    > the project, initial information is entered in a single record table that
    > will never change throughout the course of the project. Such as: Project
    > Start Date, Project Expense Code, Contractor, Number of Working Days allowed,
    > etc. 19 fields in all that won't change.
    > The other forms need access to this data. What I have done is assigned the
    > primary key the value ' 1 '. I have a field in every table that is 1 bit in
    > size and each form automatically puts a ' 1 ' in the corresponding table for
    > each record.
    > When a person opens the form they are using all the information is there and
    > it works great. Each form is based on a query that takes the information
    > from its table and the Project Info table and fills in the corresponding
    > text box.
    > I can't help but think that there may be a better way to have access to the
    > information than repeating this ' 1 ' hundreds of times even though it is a
    > tiny size field. Comboboxes would work but seem even more complicated for
    > this.
    > Thanks for any comments or advice.
     

Share This Page