Search results for query: *

Its 10pm and Its obvious that I am out of my depth here and will have to admit defeat soon and say I cant do this project. I have attached a link to the DB if you would look at it please. The encounterID was the same name, as access won't let you create a relationship unless they are. Which...

Thanks for replying. That was a typo error in my post, they do have the same name. I will remove the cascade update option and see where that gets me.

Hello again I have been working on the Db and background reading, which has confused me! I should have posted back here sooner but am rather embarrassed not to have been able to work out what I am doing. To recap. the db is to collate info from various assessments that clients undergo. The...

I had intended to send you a PM to discuss this further but I can't find a way of doing that. Perhaps this forum doesn't support that. I cant reply in more detail without breaching confidentiality rules. One of the reasons for the database is to see which assessment method, and the timing of...

Hi Thanks for taking the time to raise those points. I will discuss them with the scientists who are carrying out the study. I apologise for not replying sooner but I have been unwell, so am now back at work and going to attack this database.

Thank you both for your help and advice. I really do feel that I have learned much here. I take your points about flexibility for the future. So, now I feel a load has been lifted, and will get on an build this thing Thanks!

I have been reading thread on questionnaires and the normalization document. Sometimes I think I have had a eurek moment and then it goes away again. Do I need a tbl that gives answer codes where the assessment answers are yes/no/maybe? We need the answers in numeric form for analysis. In my...

Hi,I would agree with your points about what to include in the study if we were studying PPD itself, What we are looking at tho is the effectiveness of the current assessment methods in identifying PPD. The uniqueID relates to that delivery only not to the client alone, its a combination of the...

Hi again and thanks To clarify some points. We dont need to know which nurse, or where. The data will be used for research not client care. Demographics does use name and address. I had included details of the babe in there as the UniqueID just relates to that delivery. A mother could have a...

HI Yes, those are separate encounter dates. The client gives consent at different stages, ie to a home visit. (The legal side of this is being investigated to this may change) No,some encounters are based on a nurses observations and are recorded in the clients chart immediately, others are...

Singleton birth and Multiple Birth do apply to the client, for this delivery only. Each table represents a new mothers point of contact with a nurse. The nurse asks the mother the questions on the paper form she has to use for that encounter. The nurse sometimes makes an assessment of the...

thank you for the replies. Since I posted I deleted the table and made a new one, this has a one to one relationship. I don't know what I did differently,though I must have for there to be a difference. I have read the links and advice you kindly gave me. My DB structure was checked some...

I have a database with one main table containing demographic information of each client with UniqueID as the primary key, then 6 other tables containing data gained from interviews with the clients at different times. Unique ID is the only identical data in each table. I have these set up with...