Unsure how to catagorize

[rgreene]

Here is my scenario,
I'm working on a database for a youth shelter. I have fields for Father, Mother, Step Father, and Step Mother. I also have a check box for each that would be checked for the primary caregiver. So if mom is the primary caregive I would check the box next to mom. Same thing for the other parents. I have a report that prints out and on that form I would like the Parents Information to show. My question/problem is I want the Primary Caregivers info on the report. So on one persons report it may show his mother for a different person it may show his step father. Is there a way on the report to say who ever has the check next to primary caregive put there info here?
I hope this makes sense to someone. If not I can try to explain more.

Thanks,
Rick

 

[Fornatian]

Can there only be one primary caregiver?
Is it not possible that two people would share the caregiving - Mum and Dad, or is that too PC?
Where is the info stored for the care givers? How are they identified in their respective roles in the table? How is that related to the child?
How can the computer relate Mums record to how the checkbox info is stored?

If it is that only person can be the primary care giver then you should have an option group, not checkboxes as option groups are mutually exclusive.

Conversely - if two people can be the primary caregivers then you require a two tier set-up to support 1 to many primary care givers.

I know I've asked more questions than I've answered however they are all pertinent and will result in a better answer from anyone.

 

[rgreene]

WOW!!
OK Yes I guess there is the possiblilty of multiple cargivers but I don't think that really matters.
I have a table (tblguardians) with in that there are several fields (examples.. FatherFirst (Fathers First Name), FatherAdd (Fathers Address), SMotherAdd (Step Mothers Address), SFatherPhone (Step Fathers Phone Number)....) I also have the fields FPrimary as a yes/no and the same for MPrimary, SFPrimary, and SMPrimary. Here I would check with parent is the primary parent. Again yes i could be possible to have multiple primarys but it's mainly designed to auto fill in a field on this report. So it's not like any benefits or anything relies on which parent is considered the primary. It was just there so I could have them check which parents info they want automatically added to the report. And know I'm at a loss as how to say "if FPrimary is "yes" (or checked) then put this info here on my report. Then on the next childs report print the SMPrimary's information.
Does that help?

 

[Fornatian]

Try the following, it will allow you to set a field in the childs table to the primary key of the persons associated with that person.

Open the form, then press the 'heart' button to associate a person in the subform as the primary care giver in the child main form.

Then by running the query you can pull the records through for the child and only the record for the primary care giver will be presented in the results. Where there is no primary care giver, the record will be shown in recordset but the primary care givers field will be empty, thus indicating that one needs to be set.

Note that if you are going to duplicate the query that you must first delete the suggested relationship between the fields you set up in the relationship window then manually join the Id of the linked person with primarycare ID field in the child table. This will not affect the global relationships. By setting the join type to show all records from the Child Table and only records in the LinkedPersons Table where the fields are equal you are effectively saying, "give me all the child and primarycaregivers where you can, show blanks where not set". This is important because you don't want a child to go missing without a primarycare giver set.

I hope that's helpful and does justice to your db.