Don't know if this is correct forum? I would like to have a layout that displays records based on a value for a specific field. I have an inventory database and I would like a layout that shows items that correspond to a specific vendor.

Ideally it would update itself when a record changes as well.

I realize I'm probably making this harder than it is but the method I'm trying seems too involved.

Thanks in advance

If I understand your question correctly, You could do it through a portal..

See my example.

Let me know if I misunderstood and I'll try again. And if my solution doesn't make sense, let me know too!

test.fp7.zip

thanks.

I think you follow what I'm saying. What I'm ultimately trying to accomplish is a list of items per one specific vendor. I think that is what you sent however both vendors are present in your layout.

I'm thinking that a calculation is necessary.

I don't understand why filemaker doesn't allow me to save a query as a filter and have that on a layout?

i.e. filter records-vendor=joevendor and I have a list of records.

With the example MMS6F posted, all you have to do is switch it from List View to Form View so you only see one Vendor at a time. You'll find these options under the View menu while in browse mode.

Thanks

I got it now.

One more question. I noticed that I can scroll through the vendors and each one has a portal with the associated items in a list.

Is there anyway to link to that record in a layout from another layout?

I think you might be interested in the Go to Related Record (GTRR) script step. You can place a button in the portal so it shows up on each row and the GTRR step will take you to that related record on a layout of your choice.