Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Historical records (normalised Db)


    I have a normalised table, however i want a subform in a parent form, that will display historical records based on the agent name selected from a combobox, i can do this via the subform wizard, however the subform brings back data of how it looks in the table (i.e numbers etc..)

    can anyone suggest a way of doing this? i think i need an SQL query that will bring my data together and then present it to the subform, but i have a clue how this query would look and how id get the subform to present it
    ive done the SQL query that brings the data together

    so i now have a table that is an output of that query, this is fine

    my database is stored

    your help is appriciated thank you
    Last edited by scottemotive; 11-04-04 at 04:37.

  2. #2
    Join Date
    Oct 2004
    db attached
    Attached Files Attached Files

Posting Permissions

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