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
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?