Many to Many to Many relationship

[Channing]

Quite Simply I am having problems making the following

One Contact Table that hold Clients and Applicants (defined by Type)

One table that holds jobs

The Clients create a job in the job table

In the Job Table it adds Applicants to the job

So Jobs has many applicants

Jobs also has one Client

When I try to do this I do a join from Contacts to a JoinApplicant table to the Job

Then when I try to connect the Contacts to a seperate ID in Jobs for the one client controlled job - I get a warning that i need to make a new table occurence...

The problem with this is...

In the Contact card i want to show all Jobs a contact has created as well as - all job they may have applied for...

But because of the new Contact occurence... or Job Occurence - I can't show a portal of one or the other...

Any suggestions...

[aldipalo]

This sounds like a recruiting application.

I've been a recruiter for 40 years and have spent the last 11 months building an application for our business.

If this is correct I'd be happy to share some of my trails and tribs with you. Contact me privately.

Al

[Fenton]

If you get the warning that you need to make a new table occurrence, it means you're trying to close the circle. Which you cannot do, because FileMaker would have no idea which direction to take to get from point A to point D, if it could go thru join tables AB->D OR AC->D; and it would matter, 'cause they have different relationships on the way.

So you probably need to hang another TO off the end instead. This is pretty common when you're trying to view data from a main table somewhere further down the line, but need a different relationship than the one that got you to where you are.

Clear as mud :-?

[Channing]

Attached is a scaled down idea of what I have done - and what problems I am facing in text within the solution

SampleTest.fp7.zip

[comment]

Try it this way?

SampleTest.fp7.zip