Hello, I have been working on an Access Database with some of the folks in this site and I wanted to get feedback about my table structure to see if it is normal. I also wanted to see if, as laid out, my table design could make my forms/output look how I want.
Here is the basic gist of the form: I want to describe academic articles on cancer each with a unique [Call Number]. Four tables are related to call number unique key in a one-to-many relationship (PDF_Files, tblStudyGrading, tblGroup and tblStudyOutcomes). Because they are the most confusing, I would like the most help regarding tblGroup and its relationships as well as tblStudyOutcomes.
So we have a bunch of articles with some information about the article in tblPtCharacteristics. I want to describe the article further in tblGroup (which has a unique key GroupNumber, which relates to subsequent tables) by creating groups of patients who have data separated out in the article (for example a Control group and an Experimental group). After a user has described groups [GroupNumber] describing an article [Call Number] he or she can then describe the groups by entering characteristics about them in the tables tblAgeDesc, tblRaceDesc, and many outcomes (these are linked on tblGroup.[GroupNumber] AND tblstudyoutcomes.[OutcomeI
I want the database to work in this way. A user goes through the many forms necessary for a specific article (unique [call number]) and each will modify only those groups or outcomes related to the call number in question. Are the forms set up in a normal way that allows for this type of relationship? The way I am wanting the form controls to function is that a user selects a 'call number' from a combo box. After that selection he or she enters the remaining information on frmPtCharacteristics and then moves on to frmGroups and its associated forms (frmagedesc frmrace frmdisease) all the while, a filter is in place so that he or she only enters information pertaining to the original [call number] as linked to Group etc...
Of particular concern to me is the tblStudyOutcomes and the tables linking to both [OutcomeID] and [GroupNumber]. have I made these relationships appropriately? For better understanding an outcome could be something like 'survival at 10 years' and values for each group such as 'survival at 10 years for control' & 'survival at 10 years for experimental'.
Any help would be so welcome as I find this a confusing and difficult topic.