Welcome to SPN

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

Sign Up Now!

cascade dates

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

Tags:
  1. Warden

    Warden
    Expand Collapse
    Guest

    I have created two tables one for job orders and one for drawings. with a one
    to many relationship. one job order to many drawings. I have a field called
    Auth_date in the job order table, and in the drawing table a field for how
    long a drawing takes to develop (INTV) and a date field for the auth_date
    plus intv(dwg_complete). Next I created a form in which the job order table
    supports the primary form and the drawing table supports the subform. What I
    am trying to do is when I fill in an authorized date in the job order table
    have it automaticly caculate the the date for dwg_complete for all related
    records. All of my attempts will only update one record, the other records
    will not update until I select each one. how do i get all of them to update
    at once?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    India Candidates flock to Dera Sacha Sauda Breaking News Jan 17, 2012
    India Seven SAD Candidates of SGPC Win Unopposed Breaking News Aug 27, 2011
    GurmatChanan Updates Gurbani Download Aug 27, 2011

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 11 Jul 2006 09:21:01 -0700, Warden
    <Warden@discussions.microsoft.com> wrote:

    >I have created two tables one for job orders and one for drawings. with a one
    >to many relationship. one job order to many drawings. I have a field called
    >Auth_date in the job order table, and in the drawing table a field for how
    >long a drawing takes to develop (INTV) and a date field for the auth_date
    >plus intv(dwg_complete). Next I created a form in which the job order table
    >supports the primary form and the drawing table supports the subform. What I
    >am trying to do is when I fill in an authorized date in the job order table
    >have it automaticly caculate the the date for dwg_complete for all related
    >records. All of my attempts will only update one record, the other records
    >will not update until I select each one. how do i get all of them to update
    >at once?


    Do you really want to store this information? Since the dwg_complete
    field can (in principle) be calculated from the Auth_date and INTV
    fields, it's at least formally redundant! Do you want to be able to
    override this field?

    How are you doing the calculation? If it's on the Form, then yes, it
    will be just the active record; so don't *do* that - use an Update
    query instead, or base the subform on a Query using a calculated
    field.

    John W. Vinson[MVP]
     
  4. Warden

    Warden
    Expand Collapse
    Guest

    I am using the add date formula to caculate the date, i want to keep the
    caculated date in the table.

    "John Vinson" wrote:

    > On Tue, 11 Jul 2006 09:21:01 -0700, Warden
    > <Warden@discussions.microsoft.com> wrote:
    >
    > >I have created two tables one for job orders and one for drawings. with a one
    > >to many relationship. one job order to many drawings. I have a field called
    > >Auth_date in the job order table, and in the drawing table a field for how
    > >long a drawing takes to develop (INTV) and a date field for the auth_date
    > >plus intv(dwg_complete). Next I created a form in which the job order table
    > >supports the primary form and the drawing table supports the subform. What I
    > >am trying to do is when I fill in an authorized date in the job order table
    > >have it automaticly caculate the the date for dwg_complete for all related
    > >records. All of my attempts will only update one record, the other records
    > >will not update until I select each one. how do i get all of them to update
    > >at once?

    >
    > Do you really want to store this information? Since the dwg_complete
    > field can (in principle) be calculated from the Auth_date and INTV
    > fields, it's at least formally redundant! Do you want to be able to
    > override this field?
    >
    > How are you doing the calculation? If it's on the Form, then yes, it
    > will be just the active record; so don't *do* that - use an Update
    > query instead, or base the subform on a Query using a calculated
    > field.
    >
    > John W. Vinson[MVP]
    >
     
  5. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    Do you know why you want to keep the calculated date in the table? Doing so
    is poor practice and can lead to data anomalies. If you never need to
    override this date to allow individual drawings to have a different date
    than the group, then the best solution is to always calculate the date in
    your query. That way you are not storing redundant data, the user can't
    change the date on individual records, and you don't need to worry about
    data anomalies.

    "Warden" <Warden@discussions.microsoft.com> wrote in message
    news:9E76C445-0615-472F-A0AD-A961906F4604@microsoft.com...
    >I am using the add date formula to caculate the date, i want to keep the
    > caculated date in the table.
    >
    > "John Vinson" wrote:
    >
    >> On Tue, 11 Jul 2006 09:21:01 -0700, Warden
    >> <Warden@discussions.microsoft.com> wrote:
    >>
    >> >I have created two tables one for job orders and one for drawings. with
    >> >a one
    >> >to many relationship. one job order to many drawings. I have a field
    >> >called
    >> >Auth_date in the job order table, and in the drawing table a field for
    >> >how
    >> >long a drawing takes to develop (INTV) and a date field for the
    >> >auth_date
    >> >plus intv(dwg_complete). Next I created a form in which the job order
    >> >table
    >> >supports the primary form and the drawing table supports the subform.
    >> >What I
    >> >am trying to do is when I fill in an authorized date in the job order
    >> >table
    >> >have it automaticly caculate the the date for dwg_complete for all
    >> >related
    >> >records. All of my attempts will only update one record, the other
    >> >records
    >> >will not update until I select each one. how do i get all of them to
    >> >update
    >> >at once?

    >>
    >> Do you really want to store this information? Since the dwg_complete
    >> field can (in principle) be calculated from the Auth_date and INTV
    >> fields, it's at least formally redundant! Do you want to be able to
    >> override this field?
    >>
    >> How are you doing the calculation? If it's on the Form, then yes, it
    >> will be just the active record; so don't *do* that - use an Update
    >> query instead, or base the subform on a Query using a calculated
    >> field.
    >>
    >> John W. Vinson[MVP]
    >>
     
  6. Warden

    Warden
    Expand Collapse
    Guest

    Thank you I'll give it a try.

    "Warden" wrote:

    > I have created two tables one for job orders and one for drawings. with a one
    > to many relationship. one job order to many drawings. I have a field called
    > Auth_date in the job order table, and in the drawing table a field for how
    > long a drawing takes to develop (INTV) and a date field for the auth_date
    > plus intv(dwg_complete). Next I created a form in which the job order table
    > supports the primary form and the drawing table supports the subform. What I
    > am trying to do is when I fill in an authorized date in the job order table
    > have it automaticly caculate the the date for dwg_complete for all related
    > records. All of my attempts will only update one record, the other records
    > will not update until I select each one. how do i get all of them to update
    > at once?
     

Share This Page