Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    86

    Unanswered: Subform based on normalised database

    Hi,

    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

    my database is stored

    http://emotiveexposed.mysite.wanadoo...co.uk/test.mdb

    your help is appriciated thank you

  2. #2
    Join Date
    Oct 2004
    Posts
    86
    Ok 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
    so on creating a subform and matching the parentlink to childlink it says this table has "agent name" as Long integer

    what i need to do is on my form after each time an agent is selected i want the sub form to filter the table (normalised) for all entries previous with that agent name but display the text column and not the ID column

    this is displayed in my database in the link above(updated with queries)
    Can anyone help me with this please?

    thank you

    scott

  3. #3
    Join Date
    Oct 2004
    Posts
    86
    ok answering my own question again :-p

    Me.frmAgentHistory.LinkMasterFields = Me.cboEmployee.Column(2)
    Me.frmAgentHistory.LinkChildFields = Forms!frmAgentHistory.EmployeeName


    frmagenthistory is based on my normalised table

    so the subform is now showing the data in text format which is great, but it shows all records, how can i filter this selection by the text value (column 2) of cboEmployee

    thank you

    scott

  4. #4
    Join Date
    Oct 2004
    Posts
    86
    bump


    as still very stuck on this

Posting Permissions

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