Jump to content

Layout that shows records from field


remraf
 Share

This topic is 5681 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 5681 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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