AnsweredAssumed Answered

Displaying records from the same table in corresponding layouts

Question asked by ultranix on Dec 10, 2010
Latest reply on Dec 10, 2010 by philmodjunk

Title

Displaying records from the same table in corresponding layouts

Post

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:

  • Name,
  • Last name,
  • ID
  • and Marital Status.

The "Marital Status" is a drop-down list, which uses 3 different values:

  • empty/no data
  • Single
  • Married

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.

married.jpg

Outcomes