I'm not super familiar with how datalinq keys work, but do they only take numbers?
I'm working on an election scenario where I have a Race Select text box with a List Box that has a pull down to select any of the 435 House Races (Alabama1, Alabama2,... Nevada1, Nevada2, etc.) That is mapped to a bunch of columns, one of which fills a Race Number text box with it's own unique number, 1-435 (So Alabama District 1 is Race #1, and Wyoming's only District is Race # 435). I'm trying to figure out how to get a Datalinq Key to follow the Race Number text box for the Race I've selected. I want to go the the Race Select text box and select Alabama District 3 from the list, which will put a 3 in the Race Number text box, but I want Datalinq Key to also get a 3. TL;DR: Race Select List>Race Number Text Box>Datalinq Key.
Also, in case anyone has better ideas, here's my specific scenario: my IT dept provides an XML file of all of the races, and I can't seem to get the %relid% to work in the datalinq setup so I'm looking at trying something else. I have datalinq set up with a text box like this:
Column: Race<%relid%>\ReportingUnit\Candidate
Row: VotePerc
But that doesn't work once I put it in the sequencer, it only pulls data from the first race. So frustrated.
Thanks everyone!
------------------------------
Brian Lanciki
CHRISTIAN BROADCASTING NETWORK
------------------------------