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
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