I'm developing a beginner level solution for myself and I'm having some troubles with my table relationships.
I have 4 tables: Offices, Projects, Publications and Projects Publicated which links Projects ans Publications.
After trying many different options (with my basic FM knowledge) I got to this solution in the graph where I can create records in Projects Publicated through a portal in Publications with a Conditional Value List that allows me to choose first the office and then the project which is being publicated.
But now I would like to see the publications where the projects and offices have being publicated, but I don't know how to get from the Projects or Offices to Publications without changing this relationship that allows me this input way.
Any help would be very appreciated, maybe my logic is not the right one to get this done.
Thanks a lot