Creating a database from which the form pics program beneficiary when ID is entered

I have a program that I am running. We need to periodically check the progress of households in as far as our intervention is concerned. I want to have (if possible in kobo) a database of program beneficiaries imbedded in the form such that enumerators capture name or ID correctly and as it is in the database, in such a way that typing a name or ID that is not found in the database, the form will alert that its not there. I hope its clear

Welcome back to the community, @TauraiRonald! Maybe if you have not tried, try using the dynamic data collection as outlined in our support article: