Embedded Grid Edit Report help

Table A

• ·         field - Task (text)
• ·         field - Job Number (text)
• ·         field – Active (checkbox)
• ·         and a field called Task_Job Number which is the Key

Table B

• ·         field called Job Number (a lookup field from another table)

Table C

• ·         child table of A and B
• ·         lookup field from Table B to get the Job Number
• ·         lookup field from Table A to get the Job Number
• ·         has a conditional dropdown field
• o   show Tasks (from table A) that matches the Job Number from Table B

the conditional dropdown works fine, it only shows tasks that are for the specific job number, however, I'd like to further narrow this down to only Active tasks from Table A. On Table C Form, the dropdown is narrowed down by using a report that only shows Active Tasks as a dropdown. How can I mimic that same functionality on the embedded grid edit report on Table B as well? Currently, the grid edit only follows the conditional dropdown.

I've tried using formula fields to use as the conditional dropdown but it keeps telling me that I have to select a Job Number first even though it should already be there since it is a lookup field. Any ideas on what I'm doing wrong? (also making sure that the fields were visible in the form just in case that would cause an issue)

Hopefully, this all makes sense. I'm still learning how this particular app was made.

------------------------------
Tim D
------------------------------