[[https://www.revelation.com/|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]]


==== Popups - "F" Mode (AREV Specific) ====
=== At 28 APR 2000 01:12:43PM Dale Walker wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 01 MAY 2000 08:03PM Bill Titus wrote:  ===

<QUOTE>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.



</QUOTE>

----

=== At 02 MAY 2000 09:31AM Dale Walker wrote:  ===

<QUOTE>Thanks Bill. I will try this.



Dale

</QUOTE>

----

=== At 02 MAY 2000 12:36PM Dale Walker wrote:  ===

<QUOTE>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

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=BE82913A6787BAB0852568CF005E8C7F|View this thread on the  forum...]]