Displaying records from the same table in corresponding layouts
Hey, it's my first post here, though I've been using simple FileMaker Pro solutions for a year.
I need help on such a concept:
In order not to make it complicated, I've created 4-field database:
- Last name,
- and Marital Status.
The "Marital Status" is a drop-down list, which uses 3 different values:
- empty/no data
I also have 3 different layouts: Pool, Single and Married.
Here's the question:
How to make a person's record show in the only layout he/she belongs, I mean - whenever I set a person's status from empty/blank to Single - it only appears in "Single" layout and not in any other layout, whenever I switch person's status from "Single" to "Married", the record appears accordingly in only the "Married" layout.
I would like to repeat, that here I am using only one table and 3 layouts.
If I made my point clear, I am waiting for the answer and if something is puzzling, please, let me know, I would enrich my explanation with screenshots.