Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

Symbolic Fields on An Entry Screen Not Resolving (Arev32)

At 29 SEP 2011 09:43:09PM Paul Vallario wrote:

Can anyone help me? I have a data entry screen with many prompts. A number of prompts are symbolic xlates. In three or four of those prompts the data is the same. The first set seem to resolve ok. When I cursor down to the next section the data does not appear. Then instead of moving to the next sequential prompt it jumps to the end.

These are multivalued prompts.

I have grouped them in the correct groups and I have made sure they were all sequenced properly in the table.

Any thoughts would be appreciated. I've been working on this entry screen for days.

Thank you,

Paul


At 30 SEP 2011 08:41AM Dave Harmacek wrote:

You may have to make a special symbolic that you use only in the window. For example you have a MV master field {CUSTKEY} with the key value to the CUSTOMERS table and you want to show the customers NAME xlate symbolic next to it.

you try mv symbolic {CUSTOMERS_NAME} which has a formula of

@ANS=XLATE("CUSTOMERS", {CUSTKEY}, "NAME", "X")

and you get the problem.

try this symbolic:

@ANS=XLATE("CUSTOMERS", {CUSTKEY}, "NAME", "X")

@MV is the current row number of the group. The new formula extracts only that row number.

(yes, I know this isn't very efficient, but it works easily)

Dave

View this thread on the forum...

  • third_party_content/community/commentary/forums_nonworks/6b4a3c543982eaf78525791b000971b3.txt
  • Last modified: 2023/12/28 07:39
  • by 127.0.0.1