AnsweredAssumed Answered

Filtering Portal with drop-down list

Question asked by MauriceG on Dec 19, 2017
Latest reply on Dec 21, 2017 by MauriceG

Hi,

I’m just starting creating a solution for managing documents and, before I go too far, I’d like to make sure I’m creating the right structure.

 

Right now I have 5 tables: Dashboard, Documents, Persons, Events, Years and Categories. I have a layout based on Dashboard with a portal to Documents. The idea is to have 4 drop-down lists on that layout that will filter the documents displayed in the portal based on person, event, year or category, or one or more of these criteria (for instance, after displaying only documents of Year X, I should be able to filter down further, say by category, and so on).

 

I’ve created the first drop-down list but I can’t make the filtering work. Right now, I’ve set up the following relationships:

Dashboard::zkf_Persons = Persons::zkp_Persons

Dashboard::zkf_Documents X Documents::zkp_Documents

 

The first drop-down list is based on Persons::LastNameFirstName.

 

Is this preliminary structure ok for what I intend to do? Or what do I need to change to make it right, and make the filtering work? I suspect the relationships are not right but I do not know in which way to change them.

 

Thank for your help.

Outcomes