Business Central: Difference between revisions

Business Central (view source)

1,167 bytes added , 31 January 2022

10,739

edits

@@ Line 112: / Line 112: @@
 * Download Only
 * Upload Only
+=== How to define relations between entities? ===
+You can configure lookups using the '''Manage Lookup Mappings''' button (available for all fields with Local Type = Lookup).
+Basically, we can divide relations to two groups:
+==== Lookups defined by one field ====
+In this scenario you need to select '''Target External Entity''' and '''Target External Field''' as well.
+For example, to define the Service Order > Customer relation:
+# Select customerid as Local Field (Lookup).
+# Click '''Manage Lookup Mappings'''.
+# In the Manage Lookup Mapping window, select '''Target External Entity''' and '''Target External Field'''.
+[[File:Integration - lookup defined by one field.png|600px]]
+==== Lookups defined by one field ====
+For example, to define the Service Item Line > Service Order relation:
+# Create a composite lookup, such as "service order".
+# Select the same local field (with Local Type = Lookup) for documentNo and documentType external fields.
+# Set up the lookup mappings for both fields. In both cases, select the composite lookup "service order" that you created in the first step.
+[[File:Integration - lookup defined by two fields.png|600px]]
 === How to add a new entity to integration? ===