Switch to: V10V9V8V7V6V5

Create Object Ptr Link Dialog Help

Valentina Studio allows to create ObjectPtr links using a special dialog. You can invoke the dialog from the Schema Editor, by two ways:

Create Object Ptr Link Dialog

The dialog provides a possibilities to setup properties of the link:

  • Link Name – The name of the schema object.
  • Link Kind – The kind of link. The current dialog allows to create three kinds of links:
  • On Delete – The action, that specifies what should happens with Child-records when you delete a parent record in the linked table.
  • Table – The name of the referencing table.
    • Power – The power of the link by the referencing table. For a binary link can be 1 or M.
  • Referenced Table – The name of the referenced table.
    • Power – The power of the link by the referencing table. For a ObjectPtr link can be only 1.
  • Fields of the Referencing Table – The list of the referencing fields of the link. For ObjectPtr Link as a referencing field may be only one field of ObjectPtr type. It will be created automatically for this kind of link.
  • Fields of the Referenced Table – The list of the referenced fields of the link. For ObjectPtr Link as a referenced field may be only one field - the RecID field.
  • Show SQL – Opens dialog, that shows a SQL query, that will be applied to the datasource, to create the link.

Create Object Ptr Link Dialog - SQL Preview