This is no problem; when you create conditional formatting you have two options. either use a value or a formula. This formula can point to another field and could even contain entire calculations.
A formula could look like:
Table::RaidLevel = 0
And then you select a fill color for this level.
Then you create more formulas for every level.
Hey DaSaint thank you so much for your response. I tried that and it works great however I would like to display text defined by the RaidLevel. How would I achieve that?
Oh wow, I seem to have completely read over that. *awkward*
Sorry about that.
That would need to be a related table where you note both the raid level and the description.
So you have one table where you enter all your fields, including the raid level. (Let's call this table "Inspection")
Then you have another table where you enter your Raid Level and Raid Description. (Let's call this "RaidLevel")
In your "Inspection" table you enter a value in the Raid level field and that value is related to the Raid Level in your RaidLevel table.
On your layout you display the RaidLevel field from the Inspection table. But the Raid Description from the RaidLevel table.
On a related note I want to display the <<Raid Description>> that is in the <<Raid Level>> table in a Text Box in the <<Inspection>> table.
I thought it would simply be <<::Raid Level::Raid Description>> but that is not working correctly. Any ideas?
That should work however.
And that's how it's done in my file.
You just need to make sure you have created a correct relationship between your tables.
In "File" - "Manage" - "Database" you have a relationships tab. Check out mine and compare it to yours.
In my example it's the description field from the ReidLevel table that's on the Inspection layout.
Remove the extra ::
<<Raid Level::Raid Description>>
You can use Merge Field from the Insert menu to get the syntax perfect for inserted merge fields.
thanks guys. used PhilMdJunk's method and it worked perfectly.