Relationship query

[princeconsort]

I am busy designing a database to manage projects at work. From the attached relationship graph, you can see that there are both "timesheet" and "to dos" tables related to the "jobs" table and each of these, in turn, includes information about the relevant staff member for each record. I have designed layouts for acessing information by clients, jobs and employees; in the employees layout, I want to have portal records for "to dos" and "timesheets". At the moment, it shows me all the "timesheet" information for each staff member, but I cannot get it to do the same for the "to dos". It seems to me that some kind of relationship is needed between the "staff" and "to dos" tables, but FM won't allow another join to be created there. I hope there is a simple solution I just haven't thought about...!

[Oldsneekers]

There should be no reason why you cannot connect the staff code field in staff 2 TO to the who field in to do TO. Call your first Staff To "StaffToTime" and the second "StaffToToDo" to remember which is which later on.