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

[shawnj985]

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.

[eos]

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

[Lee Smith]

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

[shawnj985]

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.