Table Relationships: An Understanding is necessary...

Hi there,

I thought I understood table relationships in Access (2007 btw) but clearly
I'm missing something... so hope someone can assist me:

I have two tables that need to be linked: tblPatients, and tblWoundDetails.
tblWoundDetails can contain many records of a patient. The PatientID in
tblWoundDetails is selected off a drop-down lookup linking to tblPatients. I
have set up a table relationship as well, linking these two tables on
PatientID. It shows a one-to-many relationship type, and I am setting it up
to say that I want all the records from tblPatients and only those records
from tblWoundDetails where there are matching records. Now, what I want to
achieve is when opening up tblPatients it should be able to show with a
cascading + all the records from tblWoundDetails. Fristly, I am getting it
the other way round, and secondly when expanding the details from
tblWoundDetails it doesn't show the matching record from tblPatients. (I have
captured records in both tables, so it should at least show the data). Hope
all of this makes sense...

Thank you kindly!
W

--
The Psyber Fox
http://www.psyberconsulting.co.za