--- title: Understanding Intake (Client-Associated) Tables description: This article will help you understand the relationship between different client/ household-associated entities in PantrySoft. --- [Skip to content](https://support.pantrysoft.com/lesson-understanding-tables-in-advanced-report-building#main-content) English Show submenu for translations [More support](https://support.pantrysoft.com/kb-tickets/new?hsLang=en) ![pexels-caleboquendo-7807594](https://support.pantrysoft.com/hs-fs/hubfs/pexels-caleboquendo-7807594.jpeg?width=3480&height=892&name=pexels-caleboquendo-7807594.jpeg) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://support.pantrysoft.com/kb-tickets/new) - [Go to pantrysoft.com](https://app.pantrysoft.com/login) [Go to pantrysoft.com](https://app.pantrysoft.com/login) Welcome to the PantrySoft knowledge base. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://support.pantrysoft.com/?hsLang=en) 2. [FAQ & Miscellaneous](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en) 3. [Technical Documentation](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#technical-documentation) # Understanding Intake (Client-Associated) Tables ## This article will help you understand the relationship between different client/ household-associated entities in PantrySoft. ### Definition The Pantrysoft app is powered by a database which stores your data in various tables. This article shows how the different intake (Client-based) records are connected. **NOTE:** This article is a moderately deep dive on the architecture of your system, and therefore is of particular interest to data specialists and report writers. --- ### Client-Associated Structure Intake events are recorded onto records associated with the core Client (household) record, pictured here at the upper left governing everything else. Notable attached records include adding, deleting, or moving Members (which are shuffled around by altering their connecting "Member Tenure" record), and events like Registrations, Visits, Appointments, and Referrals: ![](https://support.pantrysoft.com/hs-fs/hubfs/image-png-Oct-02-2024-06-10-31-6220-PM.png?width=688&height=418&name=image-png-Oct-02-2024-06-10-31-6220-PM.png)   ### Dashboard Layout as a Diagram You'll notice if you log into Pantrysoft as a Dashboard Admin, that the main Client screen echoes these core records almost exactly; one record for one major pop-up/ modal ![](https://support.pantrysoft.com/hs-fs/hubfs/image-png-Oct-02-2024-06-16-07-0164-PM.png?width=596&height=463&name=image-png-Oct-02-2024-06-16-07-0164-PM.png) ![](https://support.pantrysoft.com/hs-fs/hubfs/image-png-Oct-02-2024-06-28-41-9547-PM.png?width=688&height=289&name=image-png-Oct-02-2024-06-28-41-9547-PM.png) ### Client-Attached Records in a Report Finally, here you can see how these records are re-linked together— sometimes by their date fields— in a fairly common report called *\*\*Visits in Range:* *![](https://support.pantrysoft.com/hs-fs/hubfs/image-png-Oct-02-2024-06-31-26-5786-PM.png?width=688&height=296&name=image-png-Oct-02-2024-06-31-26-5786-PM.png)* *![](https://support.pantrysoft.com/hs-fs/hubfs/image-png-Oct-02-2024-06-32-22-5377-PM.png?width=688&height=284&name=image-png-Oct-02-2024-06-32-22-5377-PM.png)* - [Getting Started](https://support.pantrysoft.com/getting-started?hsLang=en#main-content) - [Users](https://support.pantrysoft.com/getting-started?hsLang=en#users) - [PantrySoft Interfaces](https://support.pantrysoft.com/getting-started?hsLang=en#pantrysoft-interfaces) - [Inventory](https://support.pantrysoft.com/getting-started?hsLang=en#inventory) - [Guest/Client Registration](https://support.pantrysoft.com/getting-started?hsLang=en#guest-client-registration) - [Visits](https://support.pantrysoft.com/getting-started?hsLang=en#visits) - [Client Portal - Scheduling](https://support.pantrysoft.com/getting-started?hsLang=en#client-portal-scheduling) - [Reporting](https://support.pantrysoft.com/getting-started?hsLang=en#reporting) - [Additional Admin Guides](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#main-content) - [Client Registration & Visits](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#client-registration-visits) - [Additional Features](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#additional-features) - [Inventory Management](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#inventory-management) - [Additional Paid Features](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#additional-paid-features) - [Tags](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#tags) - [Scheduling Appointments](https://support.pantrysoft.com/additional-admin-guides?hsLang=en#scheduling-appointments) - [Scheduling and Schedule Templates](https://support.pantrysoft.com/scheduling-and-schedule-templates?hsLang=en) - [User Interfaces](https://support.pantrysoft.com/user-interfaces?hsLang=en#main-content) - [Client Portal/ Online Store- Admin & Setup Guides](https://support.pantrysoft.com/user-interfaces?hsLang=en#client-portal-online-store-admin-setup-guides) - [Client Portal/ Online Store- Customer Guides](https://support.pantrysoft.com/user-interfaces?hsLang=en#client-portal-online-store-customer-guides) - [Packing/ Kitchen Screens and Reports](https://support.pantrysoft.com/user-interfaces?hsLang=en#packing-kitchen-screens-and-reports) - [Special Workflows](https://support.pantrysoft.com/special-workflows?hsLang=en#main-content) - [Delivery/Meals on Wheels](https://support.pantrysoft.com/special-workflows?hsLang=en#delivery-meals-on-wheels) - [University](https://support.pantrysoft.com/special-workflows?hsLang=en#university) - [FAQ & Miscellaneous](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#main-content) - [Client Troubleshooting](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#client-troubleshooting) - [Other FAQs](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#other-faqs) - [Messaging and Notifications](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#messaging-and-notifications) - [Other Reports](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#other-reports) - [Technical Documentation](https://support.pantrysoft.com/faq-miscellaneous?hsLang=en#technical-documentation) - [Reporting Tools](https://support.pantrysoft.com/reporting-tools?hsLang=en#main-content) - [Merging Duplicate Client Accounts](https://support.pantrysoft.com/reporting-tools?hsLang=en#merging-duplicate-client-accounts) - [Release Notes](https://support.pantrysoft.com/release-notes?hsLang=en#main-content) - [2026 Releases](https://support.pantrysoft.com/release-notes?hsLang=en#2026-releases) - [2025 Releases](https://support.pantrysoft.com/release-notes?hsLang=en#2025-releases) - [2024 Releases](https://support.pantrysoft.com/release-notes?hsLang=en#2024-releases) - [Recorded Webinars](https://support.pantrysoft.com/recorded-webinars?hsLang=en#main-content) - [2026 Webinar Recordings](https://support.pantrysoft.com/recorded-webinars?hsLang=en#2026-webinar-recordings) - [2025 Webinar Recordings](https://support.pantrysoft.com/recorded-webinars?hsLang=en#2025-webinar-recordings) - [Special/ Niche Features](https://support.pantrysoft.com/special-niche-features?hsLang=en) - [Advanced Inventory](https://support.pantrysoft.com/advanced-inventory?hsLang=en) - [CSFP Module](https://support.pantrysoft.com/csfp-module?hsLang=en#main-content) - [CSFP Overview](https://support.pantrysoft.com/csfp-module?hsLang=en#csfp-overview) - [Managing CSFP Participants](https://support.pantrysoft.com/csfp-module?hsLang=en#managing-csfp-participants) - [Recording CSFP Visits](https://support.pantrysoft.com/csfp-module?hsLang=en#recording-csfp-visits) - [CSFP Data Management](https://support.pantrysoft.com/csfp-module?hsLang=en#csfp-data-management) - [PantrySoft Volunteer](https://support.pantrysoft.com/pantrysoft-volunteer?hsLang=en) # PantrySoft pantrysoft.com Help Center Copyright © 2026, PantrySoft