Subform based on normalised database

[scottemotive]

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-members.co.uk/test.mdb

your help is appriciated thank you

 

[scottemotive]

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

 

[scottemotive]

ok answering my own question again

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