AnsweredAssumed Answered

Table relationship question

Question asked by SteveKeiser on Sep 23, 2014
Latest reply on Sep 23, 2014 by SteveKeiser


Table relationship question


I want to make a list of all companies where they are not found in a contacts table. So I created a TO of CompanyTable and one for ContactsTable and related them by companyID_fk not equal to companyID_pk. I then created a portal from the ContactsTable context using this relationship. For those of you who intuitively understand table relationships, you know this did not work. I struggle with doing these query relationships and usually figure them out through trial and error, or outside help. So my questions are three: 1) Why doesn't this work? 2) How can I do what I want to do? 3) Where can I go to learn more about query type table relationships so I don't have to do everything by trial and error? I need to understand the underlying principles.