AnsweredAssumed Answered

Relationship problems :)

Question asked by angelestevezcalvo on Aug 2, 2018
Latest reply on Aug 12, 2018 by onefish

Hi everyone,

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

 

Screen Shot 2018-08-03 at 12.05.19.png

Outcomes