Forum Discussion
DonLarson
6 years agoQrew Elite
Andrew,
Your novel is hard to follow. Is this the architecture you are trying to describe? :
Is Related Price Type is a Look Up field in the Costs table where it is inherited from the Related Price?
I am assuming that you have three records in the Price Types Table
1 Primary
2 Secondary
3 Primary and Secondary
If so then you create a report in the Costs table, Embedded for Jobs with a Filter
Any
Related Price LU =2
Related Price LU =3
That report will only show Costs where the Parent price record has a Related Price Type = 2 or 3.
If your architecture is different, this does not help.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Your novel is hard to follow. Is this the architecture you are trying to describe? :
Is Related Price Type is a Look Up field in the Costs table where it is inherited from the Related Price?
I am assuming that you have three records in the Price Types Table
1 Primary
2 Secondary
3 Primary and Secondary
If so then you create a report in the Costs table, Embedded for Jobs with a Filter
Any
Related Price LU =2
That report will only show Costs where the Parent price record has a Related Price Type = 2 or 3.
If your architecture is different, this does not help.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
AndrewFry
6 years agoQrew Assistant Captain
Don,
Thanks for the response and sorry for the lengthy novel. That is one of my NEw YEar goals: don't write a novel when explaining something!!
I think I figured out the issue and a resolution.
I had to create a copy of the Costs form, and override the role settings by report.
Still working on a few of the details and nuances,, but it seems to be working correctly now.
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
Thanks for the response and sorry for the lengthy novel. That is one of my NEw YEar goals: don't write a novel when explaining something!!
I think I figured out the issue and a resolution.
I had to create a copy of the Costs form, and override the role settings by report.
Still working on a few of the details and nuances,, but it seems to be working correctly now.
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------