A system for generating a nested field record related to a corresponding data record is described. The system comprises a structured database for storing a plurality of the corresponding data records and a nested field record generator to query the structured database and generate the nested field record according to data selected from the corresponding data record. The nested field record generator also further derives and includes derived data from the corresponding data record in the nested field record.