AnsweredAssumed Answered

Help with relationships

Question asked by sandygjohnston on May 17, 2017
Latest reply on May 17, 2017 by Jaymo

I'm sort of a novice, and I'm trying to set up a simple Company/Contact rolodex database. 

 

I have 3 tables:

1) Company with address & phone number fields.  It also has a portal which relates properly to the Contact table (see screen shots below), but companies don't have to have employees.

2) Companies/Contacts table, which is a join table.

3) Contacts with contact fields.  Contacts don't have to be an employee of a company.

 

I think I've set up the primary keys and child keys properly (see the attached screen shot), and the Company layout works fine.  I can create contacts in the portal that are related to ABC Company.

 

But on the Contact layout, the drop-down list doesn't populate the Company fields.  When I click on the arrow to show the list of companies (those are created by calculation), I can see all the companies, but it won't populate the list.

 

And my button "Go to this Company" doesn't work either.

@

I'm sure it has something to do with how the tables are (or aren't) related.  Help?  I've been stuck on this for a while.  Help!

 

 

Outcomes