scottemotive
Registered User.
- Local time
- Today, 23:40
- Joined
- Oct 13, 2004
- Messages
- 36
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
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 here
http://emotiveexposed.mysite.wanadoo-members.co.uk/test.mdb
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 here
http://emotiveexposed.mysite.wanadoo-members.co.uk/test.mdb
