Hello all, my first post and it's a problem that has me pulling out my hair!
This will take a little while to explain and may get a little complicated!
I have a database used to manage claims that my organisation receives. When a claim is received, it is entered onto the database using a claim number (an external reference number assigned to our organisation). The initial details of the claim such as amount being claim, what type of claim it is, the date it was received; is entered into a table called "claims".
Our organisation is then expected to take the claim and progress it by obtaining various bits of information and as we do so, we update the claim record with a "Case Note". This will state the date the note was written and the note itself. It is connected by a combo box to a claim number to ensure each note is assigned to a claim number. The notes are entered onto a separate table called "notes"
Using the information that is entered into the database, a report needs to be created which is sent to the line manager providing them with the claim and how it is progressing.
This is where the problem is coming and I have reached the conclusion that it is the way the report is laid out. The only problem is, is that I have no idea what the specifics are nor how to resolve the issue. It's becoming a right pain as my ability with Access is still very much in the beginner stages. What is basically happening is that the claims records is only showing a single Note record whereas I would very much like it to show all the Note records.
I wanted to attach a copy of the database for you to take a look, which I think will help you make better sense of what I've written, however the website won't allow me to apparently. If anybody would like to take a look, please send me a message with your email address and I will send you a copy as soon as possible for you to look at.
I'd greatly appreciate any help, advice, tips, suggestions! I am reaching the limits of my ability and nearing the end of my tether!