I'm creating an app for student data in a graduate Master's program. I would like a way of indicating different user 'statuses' to show different data, such as a simple inquiry, to when they become an applicant, then a student, then an alumni. Hence a kind of opening of new conditional fields as they progress through each 'status'.
I'm new to Filemaker Pro, and it seems like creating multiple tables might be a bad idea (since they would be one-to-one relationships?), but creating one large table with different layout tabs (for inquiry, application, student, and alumni info) wouldn't be ideal because whatever that person is at that moment (either an inquiry, applicant, student, or alum), I would like that corresponding tab to show (if they are currently a student, I dont want the inquiry tab to always pop up first and have to navigate to their student tab).
An easy search feature, to pull up only students, inquiries, applicants, or alumni, in a listview is essential.
Big thank you in advance and let me know if you need any more clarity!