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.