subform

[Cherie]

I have a subform that I want to show call history. I have the Last name, First name and Date of Birth in common with all my tables that I want to use to populate the call history subform. I am really at a loss. I can get the subform to populate with the same information as the record it is on but it won't list the other calls.

Any assistants would be appreciated.

Cherie

 

[Fizzio]

Do you have duplicates of Forename, Surname and DOB in your tables for each customer? If so this is not normalised data and will cause headaches. You should link the tables (and subsequently the form/subform) using the unique ID for each customer - not the personal details.

If I am incorrect, could you explain a little bit more about your data structure and what you are trying to show?

 

[Cherie]

Unfortunenlty, we do not assign customer ID's to these calls because the caller/student's change on a yearly basis. The call log is for parents of students that are paying a fee to take our entrance exam to high school. We log each call as a new record. We then have to give a report on the types of calls we get and how we resolved the problems. They also like to know out of which city and counties have the most problems. My manager wants the CSR's to be able to see how many calls we get for a perticular student and what we did to resolve the problem. I can attach the database as a zip file because they are just dummy records right now and I will not be giving any personal data out.

Thanks for the help!

 

[Fizzio]

Go ahead, post your Db - sometimes it is easier to find a solution on a working Db

I would argue the point about not storing ID's though. Even though your students change each year, you are still storing unneccessary data by duplicating the personal details of every student.

Also would it not be nice to have the facility to study year on year the problems encountered and how they were resolved to analyse good practice and compare the frequency of problem on a yearly basis. This can help to produce a clearer strategy document (and subsequent funding) if you can show trends or how your dept has improved on last year's performance with that 'new idea you had whilst doing the shopping'. Just a thought

I would still normalise your data and archive if the data is redundant.

 

[Cherie]

Here is the other part of the db. Looks like the other finally attached.

 

[Cherie]

fizzo - Is there a way to assign the first record of a particular caller with an ID# and then have it autopopulate if they call back us back. This number would not be given out because it will confuse them as a number will be assigned to the student just prior to the testing date. IF it can do this I could probable persuade my manager to use this to help make the db work better and easier.

Thanks for all your time and patience!
Cherie

 

[Fizzio]

Here is something I have worked on. It is by no means perfect but it gives a start on where to go forward. It does not answer your question but I think the work I have done is the way to go.

I understand your trying to reach a compromise but I feel you will get in deeper and come across more problems. Let me know if you have any questions on how I have changed things over the last day or so.

 

[Cherie]

Thanks for all your effort in helping me. I may have more questions later.

Thanks Again