Fields showing up as needed??

[beaverx37]

I am trying to adjust access' student template to make a database for my camp. Basically it is what I need, but one of my field options is allergies and medication. Well if someone has one medication they take with the dosage and frequency that is great. But if someone else has 5 medications they take that is more complicated. So is there a way to make a new medication field be added as needed for people with multiple medications?



I hope this kinda explains what I asking. I am very very new to access...

[orange]

That is not the norm. Usually you would have a record for each Medication, not a separate table for each Medication.
Agree totally with the complexity comment.

Consider :

A Person may have 0 or many Medications.
A Medication may have 1 or many dosage/frequencies.

So for a specific person, you would have to relate

Person takes Medication with Dosage X and Frequency Y.

Another Person could take the same Medication with different dosage and frequency.
So you would have to be explicit with Medication, Dosage and Frequency for Each Person.

[beaverx37]

I think I understand what you are saying. I only need the medications as they pertain to my camper. I dont need to know 4 people take this same medication. Here is an example of what I want to know if is possible. Right now I have our Mr. John Smith's detail sheet, who has Med 1 as is currently displayed. But lets say he also has med 2 and med 3. Can I make him have those same entry slots (medication, dosage, frequency, and special instructions) show up again in 3 sets. but for someone who has 2 medications they only show 2 sets. So I don't have 3-4 empty sets for people with fewer medications?

[orange]

I your sample case, 1 camper has 3 Meds. This is a 1 to many relationship.
Usually you would display this using a Form and subForm where the 1 side would be presented ona Form dealing with the Camper.
The subForm would be the Many side showing each of the Meds with related dosage and frequency. The Form and subform have a common field,
the LinkFields (CamperID probably) to jkeep form and subform in sync.

What you are showing is a Form. Behind the Form is a table or possibly a query involving multiple tables or parts thereof.

I don't know your entire requirement, but my best guess would be to have a

tblCamperMeds
with fields
CamperId
MedID
MedName
MedDosage
MedFrequency
SpecialInstructions

Let's say you have Camper 37
who has 4 Meds
You could have a table with

CamperId  MedId MedName MedDosage MedFrequency SpecialInstructions
      37        2       Lipitor        40mg           1 per day   
      37        17     Norvasc      10mg           1 per day
      37        18     Xalta            5mg           2 per day     take with Orange juice
      37        20     zoffar           2mg           1 per week   take same day each week

Hope this is helpful.

For more on Form/subform see youtube look for 599CD Form subform