Forums

How to do a second read to a database table

erichon 10 Jun, 2019
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
healyhatman 10 Jun, 2019
This sounds like something you should be doing in CC

But you absolutely can have more than one read data in a form.
erichon 11 Jun, 2019
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
healyhatman 11 Jun, 2019
Sure is, just put it in the URL like
....&record={var:read_dataxxx.row.model.id}
And then retrieve it with {data:record}
This topic is locked and no more replies can be posted.