My non-profit organization owns three retirement centers. We want to build an app that records maintenance performed. I have two tables, MAINTENANCE and RESIDENTS. I have a Last Name field in the MAINTENANCE form set as REF, pointing to the RESIDENTS. The app brings up the RESIDENTS table but the ID field, not the name field.
Does anyone know what I’m doing wrong or can point me to a specific help location on how to reference a field from another table?
Thank you in advance for any help you can provide.