Many to Many

Question

Not sure how to present this...I have a table called: PRODUCTION TASKSTable is related to: JOBS TABLE (this relationship is working fine)Now, I need to relate to: SUB PAYROLL TABLE and....&nbsp; &nbsp;then from SUB PAYROLL table, I need to access the [COMPLETED BY] field and make selection from the drop-down.I am unable to make selection if it is a LOOK UP field.Is there any way to make the [COMPLETED BY] field accessible to make my selection from drop-down...and it must relate back to the data in the SUB PAYROLL table_____________ALL OF THIS DATA NEEDS TO BE CONNECTED BY THE [JOB NUMBER]&nbsp;Currently:&nbsp; [JOB NUMBER] is the (reference proxy) in the JOBS:PRODUCTION TASKS tableCurrently:&nbsp; [JOB NUMBER] is the (reference proxy) in the JOBS:SUB PAYROLL table------------------------------BuildPro------------------------------

justintorrence · Answer

@BuildPro
This is the way I am understanding your schema:

Production Tasks can have many Jobs
Sub Payrolls can have many Jobs

Let me know if I am missing somethingIf your requirement is that the user may edit one of the Sub Payroll records related to a Job from the Jobs form, the solution can be quite easy.
A way that you could do this is by adding a Report Link field in the Jobs table where Jobs: Related Sub Payroll matches the value in the field&nbsp;Sub Payroll: Record ID#.
You could then add this report link to the form, choose the&nbsp;Display the related records directly on the form radio button, and check the Editable checkbox.
Make sure that the report that the display is based upon has the&nbsp;Completed By field selected as one of the columns.
The end result should be an embedded report of all related Jobs where you can select the Completed By drop down on any of those records. This solution is not perfect and there is a risk of the end user dealing with some strange errors, but this could work.
If that is not the case and you need to edit the drop down from the Production Task form or a Report within the Job or Production Task table, the complexity of the problem expands a bit and you'll need a much more creative solution.
------------------------------Justin Torrencejtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

Forum Discussion

Many to Many