Portal a Join Table

Discussion created by jzbubble on Feb 10, 2017
Latest reply on Feb 11, 2017 by philmodjunk

I have 3 tables. Passage, Key Word, Join Table. I want to set up a database recording each passage have several key words. This is a many-to-many relationship. One passage have several key words while one key word fits several passages. In passage table, I already used portal to import the join table. It looks good but the problem is I tried to import another field ( explanation of key word) from Key Word table but failed. I don't understand. Every key word has one unique explanation. When I import the join table, I can see the key words in but the explanation can't be imported. why? How to achieve it? Thanks.