How to do a second read to a database table

Hi,
​
1. Table List is used successfully to display contents of a database table, the first two fields are displayed.
​
2. User should be able to click on the first field (customer id) in order to retrieve all the fields from that record.
​
3. User should also be able to retrieve all associated invoices which available from other database table.
​
For the 2. above, I tried to do a second Read Data in order to retrieve the whole record with respect to the user's choice of the customer id,
however error displayed, it appears that Read Data cannot be done twice in a CF form.
​
Just wonder what is the best approach to achieve the above?
​
Thank you very much in advance for your kind advice.
​
Regards,
Eric

This sounds like something you should be doing in CC
​
But you absolutely can have more than one read data in a form.

Hi Healyhatman,
​
Thanks for your advice.
​
Possible to pass a parameter from on CF form to other CF form?
​
If yes, please share the method, thanks a lot.
​
​
Regards,
Eric

Sure is, just put it in the URL like
​

....&record={var:read_dataxxx.row.model.id}

And then retrieve it with {data:record}