Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    10

    Unanswered: Access issues, relationships & error messages

    Hello,

    I have a database with the relationships as follow;

    http://imageshack.us/photo/my-images...ationships.jpg

    Uploaded with ImageShack.us

    The annual reducing balance table automatically populates the Person_ID, however I also want it to populate the support_plan_id which links it back to the support plan.

    As there could be multiple support plans with multiple annual reducing balances for each.

    Hope the above makes sense in a roundabout way if not let me know.

    Also do you know how to turn off the following warning messages when running an update query?

    http://img97.imageshack.us/img97/4562/query.jpg

    http://img35.imageshack.us/img35/5466/query1.jpg

    Ta,

    Junk

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    You lost me in that tables are not automatically populated by other tables.

    About the messages, ifyou are using VBA code, try docmd.setwarnings 0 before the queries are run, then use docmd.setwarnings -1 afterward.
    John M Reynolds

Posting Permissions

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