There is no reason why you must have a form that have every fields on the document. With some careful engineering it is possible to create a form to display and edit documents from various data sources. Of course you would need to take care of the mapping (what fields on the form display / save what data in the back end).

So basically your form layout and fields are predefined but you can choose what data is to be displayed or saved. The drawback of this method is that you need to create temporary document for the form to pull its data from.

Thanks Tinus and Howard for the reply. I will get the fields of CRM in the JSON format from a middleware server.

Tinus , That's a good idea to have predefined forms and fields and map the fields with the one received from the Server.

How ever one drawback would be we cannot change the position of the fields to match with the ones received from server

example - If you want to show a keyword field between two text fields that cannot be done if we do this way or change the keyword

field position to the bottom

Howard, I cannot use JDBC. Data is received from a middleware server in JSON format.  Will Xpages need forms with fields if I get the data as JSON format? 

Thanks for the help!