hierarchy; two fields matching one field
Hi, I'm having an issue on fmp on this subject: I have two tables that I'm working on, and one hold the name of my topic (topic) and it's id (topic_id) and the other hold the relationship between two topics (which topic is the other topics parents), being topic_id and parent_topic_id. The problem is, I'm trying to work with portals, and they don't work very well. I cannot put a related field from topics_table in my layout of relationship_table, because it cannot understand that I have two different related records. Is there a workaround? Also, is there any other way to do the hierarchy between my topics (each topic has one parent, another topic, and each parent may have many children)?