Search results

Firstly, thank you for all for getting involved! I am trying to understand some of the ways you are trying to lead me! It is difficult to reply to all individually but it seems there is a common thread of '"what is this for" and "business model". I'll try and explain. The real issue we have...

A procedure will always be associated with an admission. A complication will always be associated with either a procedure or just an admission (with no procedure) @The_doc_man You wouldn't really worry about a complication from a previous episode. On a new admission this complication just...

"This could get complex (wait... COULD?)". Ha ha. I knew I was in trouble! I must admit to thinking that I need to follow the KISS principle here (Keep It Simple Stupid) and do just what I can do. So, being a not so very good database programmer I think I like the idea of inserting a dummy/null...

ah. I can't post links to images yet...

I don't know if that will work as it is on my OneDrive. Hopefully. It is the basic tables I was talking about. The tables are not complete yet it was more of the links I am interested in.

@jdraw and @The_doc_man - Yes, the Clavien-Dindo classification was originally described for post-operative complications. However, a complication may be one not related to a procedure. For example, a patient gets admitted with a bleeding bowel (PR bleed) but then let's say has a heart attack or...

Hi Mark, Luckily in the UK NHS there is no billing issues... or unluckily as I certainly don't get the kind of salary as I would in the US! It is an 'internal' database we keep (the current horribleness is a massive excel sheet and you can just imagine the horrendous mess that is) to make sure...

"I'm pretty certain the relationship is NOT Admission-->Procedure-->Complication UNLESS there can be only ONE procedure for any given complication." The way I see it I that there can be multiple complications per procedure (there are when I operate) but there can also be multiple complications...

Wow, thank you very much for the replies. I appreciate the help. I will look at the link @jdraw, and I appreciate now @thedocman what you are saying about me being the designer. I was hoping that access would do a bit of magic re the data but I realise that is not the case so much. @plog, I had...

Hi all, I'm a relative newbie at database design and I just can't seem to get my head around how I should go about designing a database efficiently. I don't want to make any design 'clangers'. I am trying to design a custom database for us to collect audit information for our medical group. I...

Hi, I am Michael from Cornwall, UK! New to AWF but have developed a few databases. They would not stand up to any scrutiny by the members of this forum! I am looking to expand my understanding of database design and concepts and to be able to extend my knowledge of VBA/modules etc. I am...