What's my best option? Subform, iframe or something else?

[Keith-i]

I need to produce a list of results (and ultimately print a report) based upon selecting a road from an existing table and having the resulting list show all entries from the other table where the road_id matches.

If I create a fastform that accesses my roads table I can filter the data and select the road I am interested in. However, as soon as I select a road it takes me to an edit screen whereas what I really need is another form that shows all the related data based on that roads #RECORD_ID#. Am I missing the blindingly obvious?

Or am I better using a subform or iframe on the main browse form screen? All thoughts welcomed inclduing any other way of doing it.

[kev1n]

I would do it in the same way as you've done before. 2 Browse and filter the 2nd based on the selection in the 1st.

[Keith-i]

Hi kev1n

I'm having a bit of difficulty setting up some JS using nuSelectBrowse. My plan is to click on a road name in my tblRoads which will then open a new browse form (frm_values) which shows related data from the tbl_Properties and tblValues tables. Here is the custom code on the roads form (frm_roads). The primary key is a foreign key in tbl_Properties

Code: Select all

function nuSelectBrowse(e) {

var roadID = $(e.target).attr('data-nu-primary-key');
nuSetProperty('roadref',roadID)
nuForm('frm_values', '','' , '', '0');

return false;
}

Then in my second browse form (frm_values) I have this SQL to theoretically show every record that matches the hash cookie #roadref# in the id_Roads field .

Code: Select all

SELECT
 tblValues.*,
    tblProperties.*

FROM
    tblValues
        JOIN tblProperties ON tblValues.id_Properties = tblProperties.idProperties

WHERE
    ((tblProperties.id_Roads = '#roadref#'))

For convenience I also attach a diagram of my tables.

When I click on a road I just get an empty browse form showing, which doesn't even have any column headings. Neither debug or F12 help me.

[kev1n]

nuForm() expects a Form ID (e.g. "63e3d7bd4e10f60"), not a Form Code. Press Ctrl+Shift+M on the form you'd like to open to see it.

[Keith-i]

I see, thanks!
I am a step closer in that I now at least get a browse form opening up. However it doesn't show any data. If I remove the #roadref# from my SQL and put in a random road id I get results so I know the subsidiary form is working. It looks like it's not passing the hash cookie through.

[kev1n]

Try setting a global Hash Cookie:

Code: Select all

nuSetProperty('roadref',roadID, true)

If that doesn't work either, I have another trick up the sleeve...

[Keith-i]

That's the ticket. Thanks again.