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!