I have two forms created under the table named "TASKS". Form names are PCAR TASKS and RMA TASKS
I have two additional tables. First named "PCAR" second named "RMA"
Within the PCAR table, I have a form which has a relationship with TASKS. so there are multiple tasks for one PCAR project.
Within the RMA table, I have a form which has a relationship with TASKS. so there are multiple tasks for one RMA project.
My issue I am having is I want the PCAR table to reference only the PCAR TASKS form and the RMA table to only reference the RMA TASKS form.
Right now, if I click "add new task" on either PCAR or RMA, I am sent to the PCAR TASKS form. How do I set the PCAR form to only open the PCAR TASKS form & RMA form to open only the RMA TASKS form?
I have added a flow chart of what I am after. I need the relationships between the tasks and the forms to be customized.
RMA form should have a relationship with RMA tasks...PCAR form should have a relationship with PCAR tasks. However when I setup the relationship, I can only do RMA has many TASKS & PCAR has many TASKS. there is not option to select "RMA has many RMA TASKS"...Therefore it is defaulting to the PCAR Tasks for both.
Thank you!!!