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
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