Filtering Layouts

[Lars, Sweden]

Hi!

We have a problem wich we can not figure out. Our company is organized through through a system of lists with tasks, projects, responsabilities and so on. We want to

migrate from a simple system in Excel to Filemaker. Here is an example of what the "master project list" looks like:

NR PROJECT________________________DIVISION

::::::::::::::::::::::::::::::::::::::::::::::::

1. Install new lamp in office_________Janitors

2. Prepare monthly staff meeting____CEO

3. Decide on which candidate to hire_CEO

4. Move archive to new location______Janitors

This is a very simplified version but it serves as a good example. The master list shown above has to contain all records for all divisions in one place. Here is our problem: we want to have separate Filemaker Layouts for each division, for eg. showing only records concering either "Janitors" or "CEO". Is this possible?

Best regards,

Lars Jacobsson,

Sweden

Edited September 14, 2010 by Guest

[Chris Cain]

Could you not use the same layout and table, but do a find for the division you are looking for?

[Cabinetman]

I'm with you on this one.... and I don't want to use a find myself or a portal. I just want to see records where I have inventory and not out-of-stock.

I was thinking setting up a relationship would be the way to go but am drawing a blank when working on it.

After more searching I don't think it's poss. without doing a find...... or using a portal.

BUT .. if I use a portal ... can I lock it on a record so that the scroll on the mouse scrolls through the portal without clicking in it first?:?

Edited September 23, 2010 by Guest