Recent content by james.crust

Just wanted to say thanks for everyone's help. I think I am pretty much there with it now. My main mistake was defining the relationship one to one, rather than many to many (each Dsqiid can have many questions and scores, each question/score can belong to many Dsqiids). This required the...

Thank you, that was definitely the case. I have a junction table now with a join to QuestionID in the question table. Each row/record now stores the DsqiidID, QuestionID and a ScoreID. Much simpler!

Thanks for the link - I like the sound of the stump the model approach. I like the 'what if' thought scenarios. Unfortunately no one in my team would be up for taking that approach; we're just a bunch of clinicians really, no one else has any interest in this type of thing, and I took this on...

Thank you GPGeorge and jdraw I went for a walk after posting thinking it over and junction table kept nagging me in my mind. Sorry, I should have posted a view of the relationships, but taking into account what you two have said, I updated it - would this work? And would I still be able to...

Hi, new poster here, apologies if I haven't got the right forum - please let me know if I need to post elsewhere. The last 2 images are Excel drafts to try and show what I am trying to achieve. I have a screening assessment database, simple enough so far: Clients table (ClientID PK), Dsqiid...