How do I utilize the F mode in Explicit Popup information so that I can reference a single multivalued column in a specific row(record) of the table specified in the Source Table Column. The row would have to be based on the preceding multi-valued column.

I have checked The users guide, the online help - comes close but no example, the website - 0 results.

thanks,

Dale

Hi, Dale,

You asked, "How do I utilize the F mode in Explicit Popup information so that I can reference a single multivalued column in a specific row(record) of the table specified in the Source Table Column?" You can create a popup where the explicit popup information contains two pieces of data: (1) the record id of the record containing the multi-values; and (2) the field number (not name - so no symbolics) of the field holding the values.

---

Selection process 0

Mode F

Source table YOUR_FILENAME

Explicit popup information (depending on mode)

The ID of the row/record in YOUR_FILENAME goes here

The field number of the multi-value field in your record goes here

---

"The row would have to be based on the preceding multi-valued column." I take it you are selecting a single record for the popup based on the contents of the multi-value field. If so, you might select the id as part of an R/Basic program and insert it as the first value of field 4 in the popup record, then do a POPUP call.

Hope this helps.

Thanks Bill. I will try this.

Dale

With thanks to Bill Titus and Chris Leenhouts, this is what I did:

the pre-prompt for the appropriate column is as follows:

CODE COMMAND

S ROUTINENAME

ROUTINE was taken from chris' suggestion and modified as follows

popcnt=count(@record,@vm)+1

pop.rec=@record

;*this was to get the rowname in the table

to enable multi-users I then

wrote the pop.cnt to Tpopups,id (id being the user)

I then called the popup from tpopup

from tpopups,id

Worked.

Thanks to All

Dale

Dale_Walker@IntegrityOnline3.com

View this thread on the forum...