Jump to content
Sign in to follow this  
shawnj985

List my inventory on the right portal by selecting category in the left portal

Recommended Posts

I have a home asset table with a item field among other fields. I also have two other tables name category and location with a category and location text field, respectively.

In one layout with a tab, I have two portals (see attachment). The left will list my categories and the right I hope to list my items that are located in the location area. I am not sure what relationships are needed to get this to work. Once I get the category to work, I will do the same for the location tab.

The layout is based on the category table for now but that is probably wrong i Know.

post-83754-0-31073100-1343505901_thumb.j

Share this post


Link to post
Share on other sites

The layout is based on the category table for now but that is probably wrong i Know.

Since the relationships to drive these portals are not structural, there isn't really a wrong location to build the layout on, except for the point that you need some utility fields. Then it makes sense to gather them in a utility table, which in turn means you have to base your filter layout on a TO of this utility table.

See if the attached file can give you some pointers.

PS: Judging from the screenshot, you use FM12, but your profile says FM9 …

EDIT: better variable handling

Portal_Selections_2.fmp12.zip

Share this post


Link to post
Share on other sites

Hi eos,

Nice demo, thanks for sharing.

shawnj985/s profile actually shows 8.

Hi shawnj985

Please update your profile to show your current FileMaker, platform and OS information. Here is a quick link to do it.

Please do it now

Lee

Share this post


Link to post
Share on other sites

Thanks EOS, that was very nice of you to display that sample file. It did make things clearer for me. I didnt expect such a clear answer and I appreciate it.

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Will Xu 
×

Important Information

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