Thank you so much for your help. I am putting patients' blood records onto a database for research. At each visit the patient has a Full Blood count comprising 36 fields.  A patient may be at the clinic for up to 25weeks. Week 0 is the first week the patient comes to the clinic. I therefore need results for 1. each patient for 2. each week X25, for 3. 36 fields per week. I have done it now by making 10 separate tables and forms each containing 5 sets of uniquely identifiable results. Each patient can then be enterred into this cumbersome system.!!!

---

Reply from Richard Rost:

Jennifer, I'm assuming the 36 fields are for different kinds of results, not the SAME thing. Let's switch this to an analogy that I can more easily explain. Students, Classes, and Test Scores.

You've got an unlimited number of students. Each of those students can sign up for, let's say, 10 classes in a semester (your 25 weeks). Each one of those classes is going to record 4 grades (for each quarter, analogous to your 36 fields).

You need a StudentT table, a ClassT table, and a TestScoresT table. Each one is linked to the previous table with a one-to-many relationship. You could then even make three forms and make them nested subforms to track the info.

Student: Rick
--- Class: Math 101
------- TestScores
------------1Q: 99
------------2Q: 97
------------3Q: 89
etc.

Am I on the right track?