Creating Linkages Using the Visual SQL Query Builder

Before creating linkages, it is important to be aware of the Linkage Mode setting. Linkage Mode is set in the Database dialog ( File > Settings > File > Database Settings ).

Usually New or Duplicate modes are used. New mode means that the data in the database will be duplicated, and a unique row will be linked to the graphic element. Duplicate means that the data in the database will be linked to the graphic element, but neither a new row nor an mslink will be created.