I am trying to put together a master record with a unique field of patient admitNo which is not the recordID and a detail file of charges with the same admitNo.
1) I created two record sets in the behaviors selecting all the master and detail records. 2) I created the grid to display the master records including a hidden field of admitNo just in case. 3) tested and displays OK 4) I configured the detail panel with the detail recordset fields 5) In the fields panel, I set the Master Table Key Field to the admitNo from the selector and Detail Table Key Field to same.
When attempting to view the results. Both grids draw but the detail grid does not display records. The loading attempt shows when switching between master grid rows so it appear that the query is failing on the detail side.
Is this because my detail recordset should have a placeholder to the admitno? The directions do no show how to set this up as I would expect there is some substitution parameter your code would expect to insert the current row's field value. My assumption is it does this from the whole recordset internally at this point.
Could this be the result of the join fields not being recordId's? These fields are alphanumeric and not primary keys.
I do have other pages I have build with queries and they do test out so I am confident this is not a data issue.
Ideas? |
|
|