Link To Entry field: Difference between revisions

From Memento Database Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 5: Line 5:
; For one-to-one links : When an entry is created or edited, the user may select the entry in the linked library to which the new entry will be linked. If the selected entry is already linked to another entry in the current library, the attempt will be disallowed.
; For one-to-one links : When an entry is created or edited, the user may select the entry in the linked library to which the new entry will be linked. If the selected entry is already linked to another entry in the current library, the attempt will be disallowed.


Once linked, field in the linked library may be referenced from the current library from '''[[Calculation field]]''' scripts, '''[[JavaScript field]]''' scripts, and from aggregation functions.
In addition to creating a Link To Entry field in the normal fashion, one may also insert a Relationship, which accomplishes the same thing. This method may be more intuitive for some users.
 
When an entry is created, the user will be prompted to establish the value of the field, which involves accessing the target library and displaying an Entry List, enabling selection of target entry(ies). The user also may relink a library when the entry is edited.
 
Once linked, fields in the linked library may be referenced from the current library from '''[[Calculation field]]''' scripts, '''[[JavaScript field]]''' scripts, and from aggregation functions.


== Name and Hint ==
== Name and Hint ==
Line 34: Line 38:


; Dependencies : Ability to add one or more visibility dependencies upon fields with qualifying types.
; Dependencies : Ability to add one or more visibility dependencies upon fields with qualifying types.
== Examples ==
=== Companies, products, customers, orders, order line items
; To establish a one Companys to many Products link, create a one-to-many Link To Entry field within library Products to library Companys.
; To establish a one Companys to many Customers link, create a one-to-many Link To Entry field within library Customers to library Companys.
; To establish a one Customers to many Orders link, create a one-to-many Link To Entry field within library Products to library Companys.
; To establish a one Orders to many Order Line Items link, create a one-to-many Link To Entry field within library Products to library Companys.
; To establish a many Products to many Order Line Itemss link, create a many-to-many Link To Entry field within library Order Line Items to library Products.

Revision as of 16:55, 25 August 2016

A Link To Entry field may contain a link to a library.

For many-to-many links
When an entry is created or edited, the user may select the entries in the linked library to which the new entry will be linked.
For one-to-many links
When an entry is created or edited, the user may select the entry in the linked library to which the new entry will be linked.
For one-to-one links
When an entry is created or edited, the user may select the entry in the linked library to which the new entry will be linked. If the selected entry is already linked to another entry in the current library, the attempt will be disallowed.

In addition to creating a Link To Entry field in the normal fashion, one may also insert a Relationship, which accomplishes the same thing. This method may be more intuitive for some users.

When an entry is created, the user will be prompted to establish the value of the field, which involves accessing the target library and displaying an Entry List, enabling selection of target entry(ies). The user also may relink a library when the entry is edited.

Once linked, fields in the linked library may be referenced from the current library from Calculation field scripts, JavaScript field scripts, and from aggregation functions.

Name and Hint

Standard across all field types.

Advanced Parameters

Library
Select from the list the library to which you wish to link
Display aggregation
Display aggregation by entries of the linked library? Yes or no
Type of relationship
Choices are:
  • Many-to-many
  • One-to-many
  • One-to-one

    By default, it will be a many-to-many relationship.
Required
Make entry of a value mandatory before saving an entry

Display Options

Display in the list as
Select among the following roles for the current field:
  • As a Regular field
  • As an Entry Name
  • As an Entry Description
  • As an Entry Status
Display field name in Entry Edit Card?
By default, yes.
Dependencies
Ability to add one or more visibility dependencies upon fields with qualifying types.

Examples

=== Companies, products, customers, orders, order line items

To establish a one Companys to many Products link, create a one-to-many Link To Entry field within library Products to library Companys.
To establish a one Companys to many Customers link, create a one-to-many Link To Entry field within library Customers to library Companys.
To establish a one Customers to many Orders link, create a one-to-many Link To Entry field within library Products to library Companys.
To establish a one Orders to many Order Line Items link, create a one-to-many Link To Entry field within library Products to library Companys.
To establish a many Products to many Order Line Itemss link, create a many-to-many Link To Entry field within library Order Line Items to library Products.