Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2005
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    bad query (Access 2000)

    I want to make a query for the actions of each customer.I have a special table that i related with the main table but the query showing the actions somehow does not work.What may be the reason for that ? What i want is to enter the actions for each customer into a separate table bur to conect it to the table for the clients.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: bad query (Access 2000)

    You don't use a query for this. Instead, create a main form based on the clients table and a subform based on the actions table, linked by ClientID.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: bad query (Access 2000)

    To do what you want you need a form and a subform, rather than a query. Look at the attached demo.

    I have added a key field to the client actions table, and defined a relationshjip between the two tables.
    Regards
    John



  4. #4
    2 Star Lounger
    Join Date
    Aug 2005
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bad query (Access 2000)

    Dear John

    Thank you very much for the wonderful demo you have sent to me.This is exactly what i wanted and i am very grateful to you

Posting Permissions

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