Question: I am currently trying to create a rota within filemaker 16 and I can't figure out how to create records that share a date. 

I want to be able to have people assigned to jobs and jobs assigned to dates but currently when I create jobs with the same date it creates a new record instead of assigning it to the one already existing. 

I have 3 tables currently jobs, date and people. I have a 4th layout with a portal where I wanted to view records related to jobs that are set for a certain day.

Any help would be much appreciated.  

Many thanks.

Answer: 
I am not 100% convinced you need a Dates table. Do you have anything specific to record about a date, other than its existence?

However, you certainly need a *join table* of Assignments, with fields for:

* PersonID
* JobID
* Date

(this is assuming your rota is daily, otherwise you will need to indicate the shift or hours too).
I think your structure should change on this.

So instead have:
Parent:
ProjectId
Date

PersonId
JobId
Date

Then make the project Id your 'Primary Key' so your parent record.
Then you are just assigning the person, job & date as the child.

That way you can always add to the previous record without relying on date field.
You could then filter via dates etc.