Jump to content
Sign in to follow this  

How Layouts show records from Table Occurrences

Recommended Posts

Is it possible to display in a list view layout a restricted number of records without having to do a find first?

For example (attached) I have one base table called Data, and for the sake of simplicity it has one field, an ID field. There's 20 records, and they range from 1 to 20. And there's a global field called g_Ten, with the value "10"

I have a table occurrence called AllData and a table occurrence called LowData. It's a self-join and the relationship graph I have the equation LowData:ID < AllData:g_Ten

Layout 1 shows records from AllData. Layout 2 is set to show records from LowData. I expected that this would mean Layout 2 would only show me records with ID values from 1 to 9, but instead is shows me all 20 records.

Can someone explain how to get this desired result? I don't want to use portals in this particular solution. I'd rather not have to do a find first and then go to Layout 2. But if that is the proper solution I will follow it.

If it helps to understand the issue here's the real purpose for the question. I have a database watching project progress through a system. It has a Status field, and as a certain task is completed the Status is changed to a higher number. I wish to have a layout that shows, in list form the projects with status 1, a layout for status 2 etc. I don't want to use the same layout and do a simple find because users need to see different things about the project as it goes from one phase to the next.

many thanks,


Share this post

Link to post
Share on other sites

No. Layouts are based on the underlying table occurrence, not found records. You can have a button script the entire process.

If you upgrade to FMP10, you can use script triggers to perform the find for you when you enter a particular layout.

Share this post

Link to post
Share on other sites

Thanks for the reply John. I will script some buttons and start navigating with them.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.