I am trying to put together a character sheet for the British RPG 'Dragon Warriors' and am running into a repeated problem with using the Lookup command to draw data from a table. For the life of me, I cannot figure out what I am doing wrong.
I've no idea if anybody is actually active here, but in the hope they are (I can't find anywhere else to ask, either), I'm asking for some help.
What I have done so far can be downloaded at:
The last page (Calculations) is where I have the problem. There are a couple of fields of different type there, simply because I've become confused enough trying to make this work that I am not quite sure if I should be using a Text or Label Field at this point.
What I am trying to do is simple - on the first page of the sheet (Worksheet), a user can select a score for Strength (StrengthValueInputted).
I want to use this score to access the CSV file called StrengthBonuses to extract the StrengthAttBonus that goes with that selected Strength score.
I have used the syntax: Lookup('StrengthBonuses', StrengthValueInputted.Value, 'StrengthAttBonus') for the fields on the Calculation page, but it's not working.
In particular if a Strength Score of 3,4,5 is inputted, a value of -2 should be returned. For 6,7,8, a value of -1, For 13,14,15, a value of 1, for 16,17,18 a value of 2.
But nothing seems to happen.
If I can just get this licked, I think everything else is straightforward enough, but I have to do this type of call about ten times to get anywhere, and I can't even make it work once yet.
Thanks for any help.
(note, some fields may look odd, as on my own computer, I'm using a specific font that most DW players can be expected to have, but most people won't have).