Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Complicated task (Access2000)

    <P ID="del"><FONT SIZE=-1>Post deleted by princess15s</FONT>

  2. #2
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Complicated task (Access2000)

    All changes will need to be made through a form on the main fund records. then in the Afterupdate event of the form, you'd run code or update queries to update the data in the sub fund records.

    and yes, it is a poor design if the data in the sub fund records cannot be considered historical for this exact reason, which is called an update anomaly.

    Jim.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Complicated task (Access2000)

    Your answer is not gonna help me coz the database I'm using to extract data is different from the database you enter data. I haven't got permission to change the design of the data entry program.

    I AGREE, it is poorly designed, but i can't do anything about it coz it is not my program, I'm only using it to create reports.

  4. #4
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Complicated task (Access2000)

    Well you've got 2 choices then:

    1. Run update queries in your extract database before running any reports to update the sub fund data.

    2. Base your reports on the data in the main fund records and ignore the data in the sub fund records

    Jim.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •