? ? ? ? ? ? ? ? ? ? ? ? Write a code that will concatenate fields DTE, TYPE, SUBJECT And MSG from the subtable TEXTI into a? field NTESINFO? in the parent table CONTACTS. For example, for the contact SMITH, concatenate all related records in the NTES table related to SMITH. Scenario, records will be coming from a subtable which contains the above fields (displayed in a table format in the application) and place them in a notes field (A rich text box in the application). The main objective of this simple need is to joined all the above information into one field in the parent table in order to simplify data conversion of application.
? The resulting field Ntesinfo will be formated with a linspace between each variable.