Relational Design Question
I'm making a database to record jobs, employees, and other information. The problem is that each employee can have a different rate they change depending on the type of job. For example: if the job is a type 1 then the employee charges x/hour, but if it's a type 2 job then the rate is y/hour. How can I make a relationship that will join rate to both job type and employee rate for that type? I'm using filemaker pro 12.