With the changes that you have made, does one record in your contacts table represent one company or do you have multiple contacts from the same company?
There will be multiple contacts sharing the same company name
Then you should have these relationships (but I'm not actually checking the starter solutions so my names will differ from the starter solution:
Projects::_fkCompanyID = Companies::__pkCompanyID
Contacts::_fkCompanyID = Companies::__pkCompanyID
Please note that CompanyID does NOT store the name of the company--That's a different field that should only be defined in the Companies table.
So on the Contacts layout, you can add a portal to Projects and the only projects that will appear are those Projects that are linked to the same company as is the current Contact.
Please note that this may be too simplistic. Details that can complicate things are:
If it it's possible for one contact to be linked to more than one Company.
If You need to link one specific project to one specific contact--such as the company's project manager or some such.
Sorry I am really new to Filemaker, had it a couple days.
I created a table called Companies and added the 2 field you show above as well as one just called company that will hold the Company name.
From there I am lost, I also lost the link between the company field in Contacts and the company field in Project Details.
Here is what my relationships page looks like.
Sorry, I was not clear, i can create a new company record that I can select in either the contacts page or project details page and it appears to work ok. But I think the project compny field is linked to the logged in user, because if I change the company for a given project, it will change all projects that I have created to that company name.
From what I see in your screen shot, You need to add a company ID field to Contacts and then link it to Companies by CompanyID.
The next step is to look at how you link to Projects. You can link a project to a single contact or you can link it directly to the company which makes more sense depends on your business and the data you choose to store in your database. Basically you have to answer this question: "for a given project for a given company, is there one and only one contact associated with that company that needs to be linked to that project? If the answer is yes, then contacts should link to projects. If not, then companies should link to projects.