Spreadsheet: 105832d1303128657-how-to-simplify-large-database-and-use-multiple-drop-downs-eg
Sheet: Sheet1

Parent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Child
Date | Referral or Antenatal | PID No | Name | D.O.B | School Age | Referred By: | Advisor | S/C | P/M/D2/D | NEET | Postcode | Presenting Issues |  | [NAME] | Eng as 1st Lang | Add Needs | LAC | YPSS known | YPSS Work | No of child | SW | CIN |  | [NAME] | Add Needs | SW | LAC |  | Ass'ment | Act P | Drop in | CAF | Breast'f [NAME] | Smoking Info Given | Conception | Contraception | Childcare | Emotional Support needed | [NAME] | School Age | Group Work |  |  | FD | NUT | WEA | HS Vouc | School Age |  | Out                reach | Ant | CH | DG | OK | TDI | PC | EET's Support |  |  | EET's Stats |  | Not needed | IS | JSA | Council Tax | Budgetting | WTC | Social Fund | DLA | EMA | [NAME] | [NAME] | Charitable Trust | ALG | CB | Child Tax | Housing Benefit | Maintenance | Relationship Work |  |  | 121 | Acc | [NAME] | PR | Grp | Cont | OTH | Safeguarding Issues |  |  | Sexual Health |  |  | Addiction |  |  | [NAME] |  | Community Info Given | Referrals | Housing At Referral | HOUSING SUPPORT GIVEN | Status @ End | Sex | Status | Interpreter | First Language | Religion | Disabity | What….. | Ethnic Origin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Breast'f upto 1 mth | Do not smoke | Planned 1st | Sex Health Nurse | Family/Friend | Counselling Ref | Food | Mainstream | Outreach
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No | No | No | No | Breast'f 1-3 mths | CUT  Down | Planned 2nd | TPSS | Care2Learn | [NAME] | Nutrition | SGMU | Antental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Breast'f 1-3 mths + | Not in family home | Planned 3+ | Aleady have | 2 yr old pilot | Befriending | Weaning | Home Tuition
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Support 2 stop | Unplanned 1st | Do not want | 3 yr old place | PND | HS Vouchers | Not attending
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doesn't want to stop | Unplanned 2nd | Access another service | Self-financing | Mental Health |  | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unplanned 3+ |  | WTC | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 |  |  |  |  | No
 | Referral
 | Antenatal