One to One project relations in same table.
I have a "Projects" table. We often have projects that are cancelled and given new project numbers. I have set up a relationship from the Projects table to itself. I am able to create a new project an...
Forum Discussion
What I am trying to see is the opposing Job ID on each Job. On Job Canceled I want to see Job New and on Job New I want to see Job Canceled.
Using a relationship I can choose the Job ID in the lookup field of either the Canceled or the New. I prefer to create the New Job and link to the Canceled Job.
When I start with the New Job I select the Canceled Job from my lookup field and I can use the Link Report from the relationship to see the New Job on the Canceled Job but I either get the "Record ID" or the text that is entered in the "Link text" box under "Display" in the field properties. I would like to see the actual Job ID.
I also want to be able to enter notes on the New Job and have them mirrored to the Cancelled Job. With the current relationship I have to enter the notes on the Cancelled Job and they show on the New Job in a field I have set. I would rather it be one field that is mirrored but haven't been able to accomplish that as of yet.
Using a relationship I can choose the Job ID in the lookup field of either the Canceled or the New. I prefer to create the New Job and link to the Canceled Job.
When I start with the New Job I select the Canceled Job from my lookup field and I can use the Link Report from the relationship to see the New Job on the Canceled Job but I either get the "Record ID" or the text that is entered in the "Link text" box under "Display" in the field properties. I would like to see the actual Job ID.
I also want to be able to enter notes on the New Job and have them mirrored to the Cancelled Job. With the current relationship I have to enter the notes on the Cancelled Job and they show on the New Job in a field I have set. I would rather it be one field that is mirrored but haven't been able to accomplish that as of yet.