I started learning FileMaker 6.0 yesterday. I have a field called Category that contains items such as Advertising, Repairs, Supplies, Utilities, Wages, etc. I have created a layout (Payroll) that displays only the Wages records. However, when I leave this layout and go back I have all my records, not just the Wages records. How do I save the Payroll layout so it only displays Wages records?

I have a second layout (Purchases) in which I want everything except wages. I can't figure out how to do this.

Hi, rascal, and welcome to FM Forums!

Were you perhaps introduced to Filemaker via version 7? Because it sounds like maybe you are looking for certain behavior in version 6 that is specific to version 7.

In version 6, there is no connection between layouts and data. The layout simply provides an interface for getting at your data, and it is agnostic of the contents of any field (unless you direct it to behave otherwise).

The most basic method for limiting the data displayed is through a find request.

HTH,

Jerry

The most basic method for limiting the data displayed is through a find request.

And the fastest method is via relationship, if the key field can be indexed.

Thanks for the replies. I did figure out how to omit Wages from my Purchases layout.

I've been using a DOS flat file database (RapidFile) that's been obsolete since 1988. It's very easy a save a layout so that it will only display selected records. I guess I'm going have to learn about relational databases.