Forum Discussion
MCFNeil
Qrew Captain
MANNY, how you been? Sorry, its taken me 13 hours to answer this.
You will want to make sure your Vendors are connected to a "State", and that the Claim also has a "State" that match exactly. Then if the claim has the "Type" that you are using for the other conditional behavior you will combine those both into a formula text field.
Basically, you will have 2 formula text fields that have identical outputs.
[State]&"-"&[Type]
One field will be on the claim and one will be on the Vendor. Then make the conditional value be dependent on the formula field you just made.
Let me know if that make sense.
You will want to make sure your Vendors are connected to a "State", and that the Claim also has a "State" that match exactly. Then if the claim has the "Type" that you are using for the other conditional behavior you will combine those both into a formula text field.
Basically, you will have 2 formula text fields that have identical outputs.
[State]&"-"&[Type]
One field will be on the claim and one will be on the Vendor. Then make the conditional value be dependent on the formula field you just made.
Let me know if that make sense.
MCFNeil
7 years agoQrew Captain
I'm just finishing up 2 different apps that deal with Worker's Comp claims. I'm imagining that you have 2 relationships from the "vendor" table and the "claim" table for the drop-downs. (one for the defense counsel and the adjustor).
If that is true, I'd make two different reports on the vendor table. These will be used, un place of the record picker. On each of those reports, you will apply the filter for that particular 'type' of vendor.
Then the drop down can still be conditional on the state and have the pre-filtered lists for the type.
If that is true, I'd make two different reports on the vendor table. These will be used, un place of the record picker. On each of those reports, you will apply the filter for that particular 'type' of vendor.
Then the drop down can still be conditional on the state and have the pre-filtered lists for the type.