AnsweredAssumed Answered

Relational Design Question

Question asked by JonathanOxborrow on Dec 4, 2013
Latest reply on Dec 4, 2013 by JonathanOxborrow


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.