Hi,
I have one CRM form. There are some text boxes and a sub grid on the form.
1. User enter a key number on a text box, the CRM application will retrieve data from external data (SQL database) by a web resource based on the key number and fill part of text boxes and the sub grid on the
form. User have to fill data on rest of text boxes manually.
2. User click Save button. The key number and the data user manually typed will save to internal database (CRM database).
The data in SQL database will not be saved to CRM database (because redundant data)
3. Repeat step 1 and 2. Some records are saved to CRM database.
Later when user type key number he/she saved in the text box to retrieve data, the application will load data from both external and internal databases to the form.
My question is: In CRM default View how can I load the records that were saved in both external and internal database.
Thank you. Bob