#RECORD_ID# within a subform

[nickrth]

Hi brains trust,

I have a form with a subform, and I'm trying to use the subform's record id to drive a SQL statement for a select object. But #RECORD_ID# appears to return the same value for all rows in the subform.

In the screen shots below I have done a basic test to just return the record id for the given row in the select object. This is the sql code on the relevant select object:

Code: Select all

SELECT '#RECORD_ID#', '#RECORD_ID#'

And it renders the record id of the first row in the subform, for every row in the subform.

If I change it to a display object with the exact same SQL as above, it shows different IDs per record, as I'd expect.

Can anyone see what I'm doing wrong?

Thanks in advance.

[nac]

hello nickrth

The function nuSubformRowId(this) will return the PK value for a row in a subform. I use the code below with an onclick button in each row to open a modal form for the specific subform record.

Code: Select all

if (nuIsSaved()) {  
    nuPopup('606b1cefbada7f2',nuSubformRowId(this))    

} else  {  
    nuMessage(["Please save any changes before leaving this form."])
    
} 

You could set a hash cookie using the value returned by nuSubformRowId(this) to feed into your SQL statement.

Neil

[kev1n]

Hi,

Try the attached nuform.js. Replace yours with the one from the attachment and then log in again into nuBuilder.

nuform.zip

[nickrth]

That works perfectly kev1n! Thank you so much for your prompt help, I really appreciated it.

Legend!!