Nested grid relationship by date field

Developer Tony Gambee has an interesting approach to come up with a workaround.

Here what he did:

"..converted date to float, then string, then appended two fields (event id 
and date) and then converted to a string, in the pk table, I set that as 
the index in phpgrid and then again in the subgrid parameter. Because the 
same date could show up in multiple events, I created a concatenated kay 
that would relate exactly and work with date. ..."

So essentially the key becomes a string when used for referencing detail table. As long as the date field is read only, this solution will work. 

Thanks, Tony!

Richard

Feedback and Knowledge Base