Cheryl

@kpcollieryou are so right - much smarter to do all the work on the front end. Thanks again for your quick response - I am so excited to be working within Caspio for this project.

@kpcollier thanks for the insight - it sounds like I shouldn't make the mega table with all of the information, rather piece out all of the information. Would you suggest that I create separate tables for things like Property Management companies and HOA's too

Hello - creating a property management app for internal use only. When creating a table and we have a building that has multiple units - would I give the building a unique ID or each individual unit a unique ID. The intention for the app is to manage each unit, connecting tenants to that unit and creating a record of maintenance and more.