[glom] Film Manager example: Scenes: Make the Props and Costume tabs work.



commit 8bf72eda636462990315e9f4db08853efb44520e
Author: Murray Cumming <murrayc murrayc com>
Date:   Thu Oct 6 13:35:32 2011 +0200

    Film Manager example: Scenes: Make the Props and Costume tabs work.
    
    * examples/example_film_manager.glom: The relevant tables and relationships
    did not exist. Also remove all main top-level groups.

 ChangeLog                          |    7 +
 examples/example_film_manager.glom | 2603 +++++++++++++++++++++---------------
 2 files changed, 1509 insertions(+), 1101 deletions(-)
---
diff --git a/ChangeLog b/ChangeLog
index b9c006d..b7e1569 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,5 +1,12 @@
 2011-10-06  Murray Cumming  <murrayc murrayc com>
 
+	Film Manager example: Scenes: Make the Props and Costume tabs work. 
+
+	* examples/example_film_manager.glom: The relevant tables and relationships
+	did not exist. Also remove all "main" top-level groups.
+
+2011-10-06  Murray Cumming  <murrayc murrayc com>
+
 	TreeModelDb: fill_values_if_necessary(): Avoid a crash.
 
 	* glom/mode_data/datawidget/treemodel_db.cc: Do not try to use a null
diff --git a/examples/example_film_manager.glom b/examples/example_film_manager.glom
index 7b4f53a..c28d777 100644
--- a/examples/example_film_manager.glom
+++ b/examples/example_film_manager.glom
@@ -1,5 +1,5 @@
-<?xml version="1.0"?>
-<glom_document xmlns="http://glom.org/glom_document"; database_title="Openismus Film Manager" is_example="true" translation_original_locale="en_US" format_version="4">
+<?xml version="1.0" encoding="UTF-8"?>
+<glom_document xmlns="http://glom.org/glom_document"; database_title="Openismus Film Manager" is_example="true" translation_original_locale="en_US" format_version="7">
   <connection server="localhost" user="" database="glom_film_production_manager" self_hosted="true" port="5434" try_other_ports="false" hosting_mode="postgres_self"/>
   <table name="accommodation" title="Accommodation">
     <example_rows/>
@@ -9,71 +9,61 @@
     </trans_set>
     <fields>
       <field name="accommodation_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Accommodation ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Unterkunft ID"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentare"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_county" type="Text" title="County">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
     </fields>
     <relationships>
@@ -86,73 +76,71 @@
     <data_layouts>
       <data_layout name="details" parent_table="accommodation">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2">
-              <data_layout_item name="accommodation_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="accommodation_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2">
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_group name="address" title="Address">
+              <trans_set>
+                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="en_GB" val="Address"/>
+              </trans_set>
+              <data_layout_item name="address_town" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="address_street" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_county" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_country" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_group name="details" columns_count="2">
-              <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            <data_layout_group name="contact" title="Contact">
+              <trans_set>
+                <trans loc="de_DE" val="Kontakt"/>
+                <trans loc="en_GB" val="Contact"/>
+              </trans_set>
+              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_group name="address" title="Address">
-                <trans_set>
-                  <trans loc="de_DE" val="Addresse"/>
-                  <trans loc="en_GB" val="Address"/>
-                </trans_set>
-                <data_layout_item name="address_town" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_street" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_county" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_country" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_group name="contact" title="Contact">
-                <trans_set>
-                  <trans loc="de_DE" val="Kontakt"/>
-                  <trans loc="en_GB" val="Contact"/>
-                </trans_set>
-                <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
       <data_layout name="list" parent_table="accommodation">
         <data_layout_groups>
           <data_layout_group name="main">
-            <data_layout_item name="accommodation_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+            <data_layout_item name="accommodation_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
-            <data_layout_item name="name" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            <data_layout_item name="name" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
-            <data_layout_item name="address_town" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            <data_layout_item name="address_town" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="address_country" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -194,43 +182,37 @@
     </trans_set>
     <fields>
       <field name="car_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Car ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Auto ID"/>
         </trans_set>
       </field>
       <field name="manufacturer" type="Text" title="Manufacturer">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Hersteller"/>
         </trans_set>
       </field>
       <field name="model" type="Text" title="Model">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Model"/>
         </trans_set>
       </field>
       <field name="registration" type="Text" title="Registration">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kennzeichnung"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
@@ -240,17 +222,16 @@
     <data_layouts>
       <data_layout name="details" parent_table="cars">
         <data_layout_groups>
-          <data_layout_group name="main"/>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="&#xDC;bersicht"/>
+              <trans loc="de_DE" val="Ãbersicht"/>
               <trans loc="en_GB" val="Overview"/>
             </trans_set>
             <data_layout_item name="car_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="registration" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
@@ -259,16 +240,16 @@
               <trans loc="en_GB" val="Details"/>
             </trans_set>
             <data_layout_item name="manufacturer" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="model" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comment" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -277,22 +258,22 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="car_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="manufacturer" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="model" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="registration" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comment" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -304,13 +285,6 @@
   <table name="characters" title="Characters">
     <example_rows>
       <example_row>
-        <value column="character_id">0</value>
-        <value column="character">Hero Protagonist</value>
-        <value column="comments"/>
-        <value column="contact_id">3</value>
-        <value column="mainpart">TRUE</value>
-      </example_row>
-      <example_row>
         <value column="character_id">1</value>
         <value column="character">Bar Owner</value>
         <value column="comments"/>
@@ -331,6 +305,13 @@
         <value column="contact_id">6</value>
         <value column="mainpart">FALSE</value>
       </example_row>
+      <example_row>
+        <value column="character_id">0</value>
+        <value column="character">Hero Protagonist</value>
+        <value column="comments"/>
+        <value column="contact_id">3</value>
+        <value column="mainpart">TRUE</value>
+      </example_row>
     </example_rows>
     <trans_set>
       <trans loc="de_DE" val="Besetzung"/>
@@ -338,36 +319,41 @@
     </trans_set>
     <fields>
       <field name="character_id" primary_key="true" unique="true" type="Number" title="Cast ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Besetzung ID"/>
         </trans_set>
       </field>
       <field name="character" type="Text" title="Character">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Charakter"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts_actor" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts_actor" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="mainpart" default_value="FALSE" type="Boolean" title="Main Part">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Hauptrolle"/>
         </trans_set>
@@ -392,17 +378,17 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
+                <trans loc="de_DE" val="Ãbersicht"/>
                 <trans loc="en_GB" val="Overview"/>
               </trans_set>
               <data_layout_item name="character_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="character" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
@@ -416,34 +402,34 @@
                   <trans loc="en_GB" val="Actor"/>
                 </trans_set>
                 <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_street1" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_street2" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_town" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_country" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_postcode" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="picture" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="agent_id" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_group>
               <data_layout_group name="agent">
@@ -451,25 +437,25 @@
                   <trans loc="en_GB" val="Actor's Agent"/>
                 </trans_set>
                 <data_layout_item name="agent_id" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="tel_work" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_group>
-              <data_layout_portal relationship="scenes">
+              <data_layout_portal relationship="scenes" portal_rows_count="6">
                 <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="description" relationship="scene" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
           </data_layout_group>
@@ -479,78 +465,78 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="character_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="character" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
               <title_custom use_custom="true" title="Actor's Contact ID">
                 <trans_set>
                   <trans loc="de_DE" val="Schauspieler Kontakt ID"/>
                 </trans_set>
               </title_custom>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
               <title_custom use_custom="true" title="Actor's Name">
                 <trans_set>
                   <trans loc="de_DE" val="Schauspieler Name"/>
                 </trans_set>
               </title_custom>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
       <data_layout name="details" parent_table="characters">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2" title="Overview">
-              <data_layout_item name="character_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </data_layout_item>
-              <data_layout_item name="character" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
-            </data_layout_group>
-            <data_layout_group name="details" columns_count="2" title="Details">
-              <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="character_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="character" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_group name="actor" title="Actor">
+              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_group name="actor" title="Actor">
-                <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_portal relationship="scenes">
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="scenes">
+            <data_layout_portal relationship="scenes" portal_rows_count="6">
               <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="overview_name" relationship="scene" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="interior_or_exterior" relationship="scene" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="day_or_night" relationship="scene" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="minutes" relationship="scene" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_portal>
           </data_layout_group>
@@ -560,20 +546,20 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="character_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="character" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="contact_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
               <title_custom use_custom="true" title="Actor"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -585,45 +571,41 @@
           <data_layout_group>
             <data_layout_item_header>
               <data_layout_item name="org_name" relationship="system_properties" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="org_logo" relationship="system_properties" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_item_header>
             <data_layout_item_groupby border_width="0.05">
               <sortby>
-                <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="character" editable="true" use_default_formatting="true" sort_ascending="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
+                <data_layout_item name="mainpart" editable="true" use_default_formatting="true"/>
+                <data_layout_item name="character" editable="true" use_default_formatting="true" sort_ascending="true"/>
               </sortby>
               <data_layout_item name="character_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="character" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
                 <title_custom use_custom="true" title="Actor">
                   <trans_set>
                     <trans loc="de_DE" val="Schauspieler"/>
                   </trans_set>
                 </title_custom>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="picture" relationship="contacts_actor" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item_verticalgroup>
                 <data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
                   <title_custom use_custom="true" title="Agent"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="tel_work" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_item_verticalgroup>
             </data_layout_item_groupby>
@@ -694,37 +676,31 @@
     </trans_set>
     <fields>
       <field name="company_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Company ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Firma ID"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="logo" type="Image" title="Logo">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="website" type="Text" title="Web Site">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Website"/>
         </trans_set>
@@ -743,14 +719,14 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
+                <trans loc="de_DE" val="Ãbersicht"/>
                 <trans loc="en_GB" val="Overview"/>
               </trans_set>
               <data_layout_item name="company_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
@@ -759,33 +735,33 @@
                 <trans loc="en_GB" val="Details"/>
               </trans_set>
               <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="logo" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="website" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_portal relationship="staff">
+            <data_layout_portal relationship="staff" portal_rows_count="6">
               <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name_first" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name_last" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="tel_work" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="email" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_portal>
           </data_layout_group>
@@ -795,16 +771,16 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="company_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name" editable="true" use_default_formatting="true" column_width="233">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="221">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -1056,36 +1032,31 @@
     </trans_set>
     <fields>
       <field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Second Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Zweiter Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6" choices_related_show_all="true">
           <custom_choice_list>
             <custom_choice value="Mr"/>
             <custom_choice value="Ms"/>
@@ -1100,29 +1071,25 @@
         </trans_set>
       </field>
       <field name="address_street2" type="Text" title="Street (line 2)">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Strasse (2)"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6" choices_related_show_all="true">
           <custom_choice_list>
             <custom_choice value="Germany"/>
             <custom_choice value="United Kingdom"/>
@@ -1136,102 +1103,108 @@
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date Of Birth">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentare"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
         <calculation>return record["name_first"] + " " + record["name_last"]</calculation>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Vollst&#xE4;ndiger Name"/>
+          <trans loc="de_DE" val="VollstÃndiger Name"/>
         </trans_set>
       </field>
       <field name="company_id" type="Number" title="Company ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="company" choices_related_field="company_id" choices_related_second="name"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="company" choices_related_field="company_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Firma ID"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Bild"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Telefon (Privat)"/>
         </trans_set>
       </field>
       <field name="tel_mobile" type="Text" title="Mobile Telephone">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Telefon (Handy)"/>
         </trans_set>
       </field>
       <field name="tel_fax" type="Text" title="Fax">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="tel_work" type="Text" title="Work Telephone">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Telefon (Buro)"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="E-Mail"/>
         </trans_set>
       </field>
       <field name="address_street1" type="Text" title="Street (line 1)">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Strasse (1)"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Website"/>
         </trans_set>
       </field>
       <field name="agent_id" type="Number" title="Agent ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="agent" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="agent" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
       <field name="stagename" type="Text" title="Stagename">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
-          <trans loc="de_DE" val="K&#xFC;nstlername"/>
+          <trans loc="de_DE" val="KÃnstlername"/>
         </trans_set>
       </field>
     </fields>
@@ -1248,160 +1221,158 @@
     <data_layouts>
       <data_layout name="details" parent_table="contacts">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="header" columns_count="2" title="Overview">
-              <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
-                <trans loc="en_GB" val="Overview"/>
-              </trans_set>
-              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </data_layout_item>
-              <data_layout_item name="name_full" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
-            </data_layout_group>
-            <data_layout_group name="details" columns_count="2" title="Details">
-              <trans_set>
-                <trans loc="de_DE" val="Details"/>
-                <trans loc="en_GB" val="Details"/>
-              </trans_set>
-              <data_layout_notebook name="notebook_contact">
-                <data_layout_group name="name" title="Name">
-                  <trans_set>
-                    <trans loc="de_DE" val="Name"/>
-                    <trans loc="en_GB" val="Name"/>
-                  </trans_set>
-                  <data_layout_item name="name_title" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="name_first" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="name_middle" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="name_last" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                </data_layout_group>
-                <data_layout_group name="company" title="Company">
-                  <trans_set>
-                    <trans loc="de_DE" val="Firma"/>
-                    <trans loc="en_GB" val="Company"/>
-                  </trans_set>
-                  <data_layout_item name="company_id" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                  </data_layout_item>
-                  <data_layout_item name="name" relationship="company" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                </data_layout_group>
-                <data_layout_group name="address" title="Address">
-                  <trans_set>
-                    <trans loc="de_DE" val="Addresse"/>
-                    <trans loc="en_GB" val="Address"/>
-                  </trans_set>
-                  <data_layout_item name="address_street1" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_street2" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_town" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_state" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_country" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                </data_layout_group>
-                <data_layout_group name="telephone" title="Telephone">
-                  <trans_set>
-                    <trans loc="de_DE" val="Telefon"/>
-                    <trans loc="en_GB" val="Telephone"/>
-                  </trans_set>
-                  <data_layout_item name="tel_work" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="tel_mobile" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <trans_set>
+              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="en_GB" val="Overview"/>
+            </trans_set>
+            <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <trans_set>
+              <trans loc="de_DE" val="Details"/>
+              <trans loc="en_GB" val="Details"/>
+            </trans_set>
+            <data_layout_notebook name="notebook_contact">
+              <data_layout_group name="name" title="Name">
+                <trans_set>
+                  <trans loc="de_DE" val="Name"/>
+                  <trans loc="en_GB" val="Name"/>
+                </trans_set>
+                <data_layout_item name="name_title" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name_first" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name_middle" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name_last" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_group name="company" title="Company">
+                <trans_set>
+                  <trans loc="de_DE" val="Firma"/>
+                  <trans loc="en_GB" val="Company"/>
+                </trans_set>
+                <data_layout_item name="company_id" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="company" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_group name="address" title="Address">
+                <trans_set>
+                  <trans loc="de_DE" val="Addresse"/>
+                  <trans loc="en_GB" val="Address"/>
+                </trans_set>
+                <data_layout_item name="address_street1" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_street2" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_town" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_state" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_country" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_group name="telephone" title="Telephone">
+                <trans_set>
+                  <trans loc="de_DE" val="Telefon"/>
+                  <trans loc="en_GB" val="Telephone"/>
+                </trans_set>
+                <data_layout_item name="tel_work" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="tel_mobile" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="tel_home" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="tel_fax" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_group name="agent" title="Agent">
+                <trans_set>
+                  <trans loc="de_DE" val="Agent"/>
+                  <trans loc="en_GB" val="Agent"/>
+                </trans_set>
+                <data_layout_item name="agent_id" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name_full" relationship="agent" editable="true" use_default_formatting="true">
+                  <title_custom/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_notebook>
+            <data_layout_notebook name="notebook_related">
+              <data_layout_group name="crew" title="Crew">
+                <trans_set>
+                  <trans loc="de_DE" val="Crew"/>
+                  <trans loc="en_GB" val="Crew"/>
+                </trans_set>
+                <data_layout_portal relationship="crew" portal_rows_count="6">
+                  <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
+                    <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                   </data_layout_item>
-                  <data_layout_item name="tel_home" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <data_layout_item name="description" editable="true" use_default_formatting="true">
+                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                   </data_layout_item>
-                  <data_layout_item name="tel_fax" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_portal>
+              </data_layout_group>
+              <data_layout_group name="cast" title="Cast">
+                <trans_set>
+                  <trans loc="de_DE" val="Cast"/>
+                  <trans loc="en_GB" val="Cast"/>
+                </trans_set>
+                <data_layout_portal relationship="cast" portal_rows_count="6">
+                  <data_layout_item name="character_id" editable="true" use_default_formatting="true">
+                    <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                   </data_layout_item>
-                </data_layout_group>
-                <data_layout_group name="agent" title="Agent">
-                  <trans_set>
-                    <trans loc="de_DE" val="Agent"/>
-                    <trans loc="en_GB" val="Agent"/>
-                  </trans_set>
-                  <data_layout_item name="agent_id" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <data_layout_item name="character" editable="true" use_default_formatting="true">
+                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                   </data_layout_item>
-                  <data_layout_item name="name_full" relationship="agent" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                    <title_custom/>
+                  <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
+                    <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                   </data_layout_item>
-                </data_layout_group>
-              </data_layout_notebook>
-              <data_layout_notebook name="notebook_related">
-                <data_layout_group name="crew" title="Crew">
-                  <trans_set>
-                    <trans loc="de_DE" val="Crew"/>
-                    <trans loc="en_GB" val="Crew"/>
-                  </trans_set>
-                  <data_layout_portal relationship="crew">
-                    <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
-                      <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                    </data_layout_item>
-                    <data_layout_item name="description" editable="true" use_default_formatting="true">
-                      <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                    </data_layout_item>
-                  </data_layout_portal>
-                </data_layout_group>
-                <data_layout_group name="cast" title="Cast">
-                  <trans_set>
-                    <trans loc="de_DE" val="Cast"/>
-                    <trans loc="en_GB" val="Cast"/>
-                  </trans_set>
-                  <data_layout_portal relationship="cast">
-                    <data_layout_item name="character_id" editable="true" use_default_formatting="true">
-                      <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                    </data_layout_item>
-                    <data_layout_item name="character" editable="true" use_default_formatting="true">
-                      <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                    </data_layout_item>
-                    <data_layout_item name="mainpart" editable="true" use_default_formatting="true">
-                      <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                    </data_layout_item>
-                  </data_layout_portal>
-                </data_layout_group>
-              </data_layout_notebook>
-              <data_layout_item name="email" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
-              <data_layout_item name="website" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
-              <data_layout_item name="date_of_birth" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </data_layout_item>
-              <data_layout_item name="picture" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </data_layout_item>
-              <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
-            </data_layout_group>
+                </data_layout_portal>
+              </data_layout_group>
+            </data_layout_notebook>
+            <data_layout_item name="email" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="website" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="date_of_birth" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="picture" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
@@ -1409,24 +1380,24 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="contact_id" editable="true" use_default_formatting="true" column_width="100">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
               <title_custom/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_first" editable="true" use_default_formatting="true" column_width="100">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_last" editable="true" use_default_formatting="true" column_width="162">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="address_country" editable="true" use_default_formatting="true" column_width="100">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name" relationship="company" editable="true" use_default_formatting="true" column_width="147">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
               <title_custom use_custom="true" title="Company Name"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -1441,7 +1412,7 @@
                 <formatting/>
               </data_layout_item>
               <data_layout_item name="name_full" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_item_groupby>
           </data_layout_group>
@@ -1456,10 +1427,10 @@
                   <formatting/>
                 </data_layout_item>
                 <data_layout_item name="name_full" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_item_groupby>
             </data_layout_item_groupby>
@@ -1469,55 +1440,152 @@
     </reports>
     <print_layouts/>
   </table>
-  <table name="crew" title="Crew">
+  <table name="costume" title="Costume">
     <example_rows>
       <example_row>
-        <value column="crew_id">0</value>
-        <value column="description">Main Camera Man</value>
+        <value column="costume_id">0</value>
+        <value column="description">Spangled Leather</value>
         <value column="comments"/>
-        <value column="dept_id">1</value>
-        <value column="contact_id">7</value>
+        <value column="name">Poncho</value>
       </example_row>
       <example_row>
-        <value column="crew_id">1</value>
-        <value column="description">Chief Sound Man</value>
+        <value column="costume_id">1</value>
+        <value column="description"/>
         <value column="comments"/>
-        <value column="dept_id">0</value>
-        <value column="contact_id">8</value>
+        <value column="name">Black Hat</value>
+      </example_row>
+      <example_row>
+        <value column="costume_id">2</value>
+        <value column="description"/>
+        <value column="comments"/>
+        <value column="name">Denim Dungarees</value>
+      </example_row>
+      <example_row>
+        <value column="costume_id">3</value>
+        <value column="description"/>
+        <value column="comments"/>
+        <value column="name">Yellow Shirt</value>
       </example_row>
     </example_rows>
-    <trans_set>
-      <trans loc="en_GB" val="Crew"/>
-    </trans_set>
     <fields>
-      <field name="crew_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Crew ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+      <field name="costume_id" primary_key="true" auto_increment="true" type="Number" title="Costume ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-        <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
-        </trans_set>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
-        <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
-        </trans_set>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
-      <field name="dept_id" type="Number" title="Department ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="departments" choices_related_field="departments_id" choices_related_second="name"/>
-        <trans_set>
-          <trans loc="de_DE" val="Abteilung ID"/>
-        </trans_set>
+      <field name="name" type="Text" title="Name">
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+      </field>
+    </fields>
+    <relationships/>
+    <data_layouts>
+      <data_layout name="list" parent_table="costume">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="costume_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="details" parent_table="costume">
+        <data_layout_groups>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="costume_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
+    <reports/>
+    <print_layouts/>
+  </table>
+  <table name="crew" title="Crew">
+    <example_rows>
+      <example_row>
+        <value column="crew_id">0</value>
+        <value column="description">Main Camera Man</value>
+        <value column="comments"/>
+        <value column="dept_id">1</value>
+        <value column="contact_id">7</value>
+      </example_row>
+      <example_row>
+        <value column="crew_id">1</value>
+        <value column="description">Chief Sound Man</value>
+        <value column="comments"/>
+        <value column="dept_id">0</value>
+        <value column="contact_id">8</value>
+      </example_row>
+    </example_rows>
+    <trans_set>
+      <trans loc="en_GB" val="Crew"/>
+    </trans_set>
+    <fields>
+      <field name="crew_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Crew ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+      </field>
+      <field name="description" type="Text" title="Description">
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+        <trans_set>
+          <trans loc="de_DE" val="Beschreibung"/>
+        </trans_set>
+      </field>
+      <field name="comments" type="Text" title="Comments">
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+        <trans_set>
+          <trans loc="de_DE" val="Kommentar"/>
+        </trans_set>
+      </field>
+      <field name="dept_id" type="Number" title="Department ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="departments" choices_related_field="departments_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
+        <trans_set>
+          <trans loc="de_DE" val="Abteilung ID"/>
+        </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
@@ -1546,96 +1614,94 @@
     <data_layouts>
       <data_layout name="details" parent_table="crew">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2" title="Overview">
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <trans_set>
+              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="en_GB" val="Overview"/>
+            </trans_set>
+            <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <trans_set>
+              <trans loc="de_DE" val="Details"/>
+              <trans loc="en_GB" val="Details"/>
+            </trans_set>
+            <data_layout_group name="department" title="Department">
               <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
-                <trans loc="en_GB" val="Overview"/>
+                <trans loc="de_DE" val="Abteilung"/>
+                <trans loc="en_GB" val="Department"/>
               </trans_set>
-              <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <data_layout_item name="dept_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="name" relationship="departments" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_group name="contact" title="Contact">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
-                <trans loc="en_GB" val="Details"/>
+                <trans loc="de_DE" val="Kontakt"/>
+                <trans loc="en_GB" val="Contact"/>
               </trans_set>
-              <data_layout_group name="department" title="Department">
+              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_group name="address" title="Address">
                 <trans_set>
-                  <trans loc="de_DE" val="Abteilung"/>
-                  <trans loc="en_GB" val="Department"/>
+                  <trans loc="de_DE" val="Addresse"/>
+                  <trans loc="en_GB" val="Address"/>
                 </trans_set>
-                <data_layout_item name="dept_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <data_layout_item name="address_street1" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_street2" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
-                <data_layout_item name="name" relationship="departments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <data_layout_item name="address_town" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_state" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_country" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="address_postcode" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_group>
-              <data_layout_group name="contact" title="Contact">
+              <data_layout_group name="agent" title="Agent">
                 <trans_set>
-                  <trans loc="de_DE" val="Kontakt"/>
-                  <trans loc="en_GB" val="Contact"/>
+                  <trans loc="de_DE" val="Agent"/>
+                  <trans loc="en_GB" val="Agent"/>
                 </trans_set>
-                <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <data_layout_item name="agent_id" relationship="contacts" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
-                <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <data_layout_item name="name_full" relationship="contacts" related_relationship="agent" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
-                <data_layout_group name="address" title="Address">
-                  <trans_set>
-                    <trans loc="de_DE" val="Addresse"/>
-                    <trans loc="en_GB" val="Address"/>
-                  </trans_set>
-                  <data_layout_item name="address_street1" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_street2" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_town" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_state" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_country" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                  <data_layout_item name="address_postcode" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                </data_layout_group>
-                <data_layout_group name="agent" title="Agent">
-                  <trans_set>
-                    <trans loc="de_DE" val="Agent"/>
-                    <trans loc="en_GB" val="Agent"/>
-                  </trans_set>
-                  <data_layout_item name="agent_id" relationship="contacts" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                  </data_layout_item>
-                  <data_layout_item name="name_full" relationship="contacts" related_relationship="agent" editable="true" use_default_formatting="true">
-                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  </data_layout_item>
-                </data_layout_group>
               </data_layout_group>
-              <data_layout_portal relationship="scenes">
-                <data_layout_item name="scene_id" use_default_formatting="true" column_width="90">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="overview_name" relationship="scenes" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_portal>
-              <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
             </data_layout_group>
+            <data_layout_portal relationship="scenes" portal_rows_count="6">
+              <data_layout_item name="scene_id" use_default_formatting="true" column_width="90">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="overview_name" relationship="scenes" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+            </data_layout_portal>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
@@ -1643,27 +1709,27 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="crew_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="contact_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="dept_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name" relationship="departments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
               <title_custom use_custom="true" title="Department Name">
                 <trans_set>
                   <trans loc="de_DE" val="Abteilungsname"/>
                 </trans_set>
               </title_custom>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -1675,7 +1741,6 @@
           <data_layout_group>
             <data_layout_item_groupby border_width="0.05">
               <groupby name="name" relationship="departments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
                 <title_custom use_custom="true" title="Department Name">
                   <trans_set>
                     <trans loc="de_DE" val="Abteilungsname"/>
@@ -1683,47 +1748,45 @@
                 </title_custom>
               </groupby>
               <sortby>
-                <data_layout_item name="name_last" relationship="contacts" editable="true" use_default_formatting="true" sort_ascending="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
+                <data_layout_item name="name_last" relationship="contacts" editable="true" use_default_formatting="true" sort_ascending="true"/>
               </sortby>
               <data_layout_item name="department_id" editable="true" use_default_formatting="true">
                 <formatting/>
               </data_layout_item>
               <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item_verticalgroup>
                 <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
                   <title_custom/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_street1" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_street2" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_town" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_state" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_country" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="address_postcode" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_item_verticalgroup>
               <data_layout_item_verticalgroup>
                 <data_layout_item name="name_full" relationship="contacts" related_relationship="agent" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_item_verticalgroup>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_item_groupby>
           </data_layout_group>
@@ -1743,78 +1806,87 @@
     </trans_set>
     <fields>
       <field name="delivery_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Delivery ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Lieferung ID"/>
         </trans_set>
       </field>
       <field name="arrival_date" type="Number" title="Arrival Date">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Lieferungsdatum"/>
         </trans_set>
       </field>
       <field name="departure_contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="departure_contact" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="departure_contact" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="arrival_contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="arrival_contact" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="arrival_contact" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="arrival_time" type="Time" title="Arrival Time">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Lieferungszeit"/>
         </trans_set>
       </field>
       <field name="arrival_place" type="Text" title="Arrival Place">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Lieferungsaddresse"/>
         </trans_set>
       </field>
       <field name="departure_time" type="Time" title="Departure Time">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Sendungszeit"/>
         </trans_set>
       </field>
       <field name="departure_date" type="Date" title="Departure Date">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Sendungsdatum"/>
         </trans_set>
       </field>
       <field name="departure_place" type="Text" title="Departure Place">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Sendungsaddresse"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentare"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
         </trans_set>
@@ -1837,99 +1909,99 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="delivery_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_full" relationship="departure_contact" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
               <title_custom use_custom="true" title="Departure Name">
                 <trans_set>
                   <trans loc="de_DE" val="Sendername"/>
                 </trans_set>
               </title_custom>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="departure_place" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="departure_date" editable="true" use_default_formatting="true" column_width="77">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_full" relationship="arrival_contact" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
               <title_custom use_custom="true" title="Arrival Name">
                 <trans_set>
-                  <trans loc="de_DE" val="Empf&#xE4;ngerkontakt"/>
+                  <trans loc="de_DE" val="EmpfÃngerkontakt"/>
                 </trans_set>
               </title_custom>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="arrival_place" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="arrival_date" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
       <data_layout name="details" parent_table="deliveries">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2">
-              <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="delivery_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_group name="departure" title="Departure">
+              <trans_set>
+                <trans loc="de_DE" val="Departure"/>
+                <trans loc="en_GB" val="Departure"/>
+              </trans_set>
+              <data_layout_item name="departure_contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="name_full" relationship="departure_contact" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="departure_place" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="departure_date" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="delivery_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <data_layout_item name="departure_time" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_group name="details" columns_count="2">
-              <data_layout_group name="departure" title="Departure">
-                <trans_set>
-                  <trans loc="de_DE" val="Departure"/>
-                  <trans loc="en_GB" val="Departure"/>
-                </trans_set>
-                <data_layout_item name="departure_contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="departure_contact" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="departure_place" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="departure_date" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="departure_time" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_group name="arrival" title="Arrival">
-                <trans_set>
-                  <trans loc="de_DE" val="Arrival"/>
-                  <trans loc="en_GB" val="Arrival"/>
-                </trans_set>
-                <data_layout_item name="arrival_contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="arrival_contact" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="arrival_place" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="arrival_date" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="arrival_time" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-              </data_layout_group>
+            <data_layout_group name="arrival" title="Arrival">
+              <trans_set>
+                <trans loc="de_DE" val="Arrival"/>
+                <trans loc="en_GB" val="Arrival"/>
+              </trans_set>
+              <data_layout_item name="arrival_contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="name_full" relationship="arrival_contact" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="arrival_place" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="arrival_date" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="arrival_time" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
             </data_layout_group>
+          </data_layout_group>
+          <data_layout_group name="comments">
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -1987,19 +2059,16 @@
     </trans_set>
     <fields>
       <field name="departments_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Department ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Abteilung ID"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
@@ -2015,43 +2084,41 @@
     <data_layouts>
       <data_layout name="details" parent_table="departments">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2" title="Overview">
-              <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
-                <trans loc="en_GB" val="Overview"/>
-              </trans_set>
-              <data_layout_item name="departments_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <trans_set>
+              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="en_GB" val="Overview"/>
+            </trans_set>
+            <data_layout_item name="departments_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" title="Details">
+            <trans_set>
+              <trans loc="de_DE" val="Details"/>
+              <trans loc="en_GB" val="Details"/>
+            </trans_set>
+            <data_layout_portal relationship="department_crew" portal_rows_count="6">
+              <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
+                <title_custom/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="description" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-            </data_layout_group>
-            <data_layout_group name="details" title="Details">
-              <trans_set>
-                <trans loc="de_DE" val="Details"/>
-                <trans loc="en_GB" val="Details"/>
-              </trans_set>
-              <data_layout_portal relationship="department_crew">
-                <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                  <title_custom/>
-                </data_layout_item>
-                <data_layout_item name="description" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_portal>
-              <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-            </data_layout_group>
+              <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+            </data_layout_portal>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
@@ -2074,13 +2141,13 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="departments_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2112,23 +2179,20 @@
     </trans_set>
     <fields>
       <field name="equipment_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Equipment ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="en_GB" val="Equipment ID"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
           <trans loc="en_GB" val="Description"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
           <trans loc="en_GB" val="Comments"/>
@@ -2146,36 +2210,34 @@
     <data_layouts>
       <data_layout name="details" parent_table="equipment">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2" title="Overview">
-              <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
-                <trans loc="en_GB" val="Overview"/>
-              </trans_set>
-              <data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </data_layout_item>
-            </data_layout_group>
-            <data_layout_group name="details" columns_count="2" title="Details">
-              <trans_set>
-                <trans loc="de_DE" val="Details"/>
-                <trans loc="en_GB" val="Details"/>
-              </trans_set>
-              <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <trans_set>
+              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="en_GB" val="Overview"/>
+            </trans_set>
+            <data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <trans_set>
+              <trans loc="de_DE" val="Details"/>
+              <trans loc="en_GB" val="Details"/>
+            </trans_set>
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_portal relationship="scenes" portal_rows_count="6">
+              <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_portal relationship="scenes">
-                <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="overview_name" relationship="scene" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_portal>
-              <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="overview_name" relationship="scene" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-            </data_layout_group>
+            </data_layout_portal>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
@@ -2183,13 +2245,13 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="equipment_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2219,53 +2281,53 @@
     </trans_set>
     <fields>
       <field name="journey_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Journey ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Fahrt ID"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="arrival_date" type="Date" title="Arrival Date">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="arrival_time" type="Time" title="Arrival Time">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="arrival_place" type="Text" title="Arrival Place">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="departure_date" type="Date" title="Departure Date">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="departure_time" type="Time" title="Departure Time">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="departure_place" type="Text" title="Departure Place">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Kontakt ID"/>
         </trans_set>
@@ -2283,86 +2345,86 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="journey_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="192">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="arrival_place" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="arrival_date" editable="true" use_default_formatting="true" column_width="101">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="departure_place" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="departure_date" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
       <data_layout name="details" parent_table="journeys">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2">
-              <data_layout_item name="journey_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="journey_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_group name="person" title="Person">
+              <trans_set>
+                <trans loc="de_DE" val="Person"/>
+                <trans loc="en_GB" val="Person"/>
+              </trans_set>
+              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="name_full" relationship="contacts" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_group name="details" columns_count="2">
-              <data_layout_group name="person" title="Person">
-                <trans_set>
-                  <trans loc="de_DE" val="Person"/>
-                  <trans loc="en_GB" val="Person"/>
-                </trans_set>
-                <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="contacts" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_group name="departure" title="Departure">
-                <trans_set>
-                  <trans loc="de_DE" val="Departure"/>
-                  <trans loc="en_GB" val="Departure"/>
-                </trans_set>
-                <data_layout_item name="departure_place" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="departure_date" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="departure_time" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_group name="arrival" title="Arrival">
-                <trans_set>
-                  <trans loc="de_DE" val="Arrival"/>
-                  <trans loc="en_GB" val="Arrival"/>
-                </trans_set>
-                <data_layout_item name="arrival_place" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="arrival_date" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="arrival_time" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-              </data_layout_group>
+            <data_layout_group name="departure" title="Departure">
+              <trans_set>
+                <trans loc="de_DE" val="Departure"/>
+                <trans loc="en_GB" val="Departure"/>
+              </trans_set>
+              <data_layout_item name="departure_place" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="departure_date" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="departure_time" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
             </data_layout_group>
+            <data_layout_group name="arrival" title="Arrival">
+              <trans_set>
+                <trans loc="de_DE" val="Arrival"/>
+                <trans loc="en_GB" val="Arrival"/>
+              </trans_set>
+              <data_layout_item name="arrival_place" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="arrival_date" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="arrival_time" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+            </data_layout_group>
+          </data_layout_group>
+          <data_layout_group name="comments">
             <data_layout_item name="comment" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2403,62 +2465,62 @@
     </trans_set>
     <fields>
       <field name="location_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Location ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="name" type="Text" title="Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="address_street" type="Text" title="Street">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Stadt"/>
         </trans_set>
       </field>
       <field name="address_county" type="Text" title="County">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Land"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Staat"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
       <field name="rent" type="Number" title="Rent">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
     </fields>
     <relationships>
@@ -2472,71 +2534,71 @@
     <data_layouts>
       <data_layout name="details" parent_table="locations">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2">
-              <data_layout_item name="location_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="location_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_group name="address" title="Address">
+              <trans_set>
+                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="en_GB" val="Address"/>
+              </trans_set>
+              <data_layout_item name="address_street" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="address_town" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_county" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_country" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_group name="details" columns_count="2">
-              <data_layout_group name="address" title="Address">
-                <trans_set>
-                  <trans loc="de_DE" val="Addresse"/>
-                  <trans loc="en_GB" val="Address"/>
-                </trans_set>
-                <data_layout_item name="address_street" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_town" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_county" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_country" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_postcode" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_group name="contact_person" title="Contact Person">
-                <trans_set>
-                  <trans loc="de_DE" val="Contact Person"/>
-                </trans_set>
-                <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
+            <data_layout_group name="contact_person" title="Contact Person">
+              <trans_set>
+                <trans loc="de_DE" val="Contact Person"/>
+              </trans_set>
+              <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
             </data_layout_group>
-            <data_layout_portal relationship="scenes">
+          </data_layout_group>
+          <data_layout_group name="more">
+            <data_layout_portal relationship="scenes" portal_rows_count="6">
               <data_layout_item name="date" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="time" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="day_or_night" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="location_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_portal>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2545,16 +2607,16 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="location_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="address_town" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="address_country" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2565,13 +2627,13 @@
         <data_layout_groups>
           <data_layout_group>
             <data_layout_item name="location_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="name" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="address_town" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2582,6 +2644,82 @@
     </reports>
     <print_layouts/>
   </table>
+  <table name="props" title="Props">
+    <example_rows>
+      <example_row>
+        <value column="prop_id">0</value>
+        <value column="description"/>
+        <value column="comments"/>
+        <value column="name">Gatling Gun</value>
+      </example_row>
+      <example_row>
+        <value column="prop_id">1</value>
+        <value column="description">Safety Glass</value>
+        <value column="comments"/>
+        <value column="name">Whiskey Bottle</value>
+      </example_row>
+      <example_row>
+        <value column="prop_id">2</value>
+        <value column="description">Ceramic</value>
+        <value column="comments"/>
+        <value column="name">Flower Pot</value>
+      </example_row>
+    </example_rows>
+    <fields>
+      <field name="prop_id" primary_key="true" auto_increment="true" type="Number" title="Prop ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+      </field>
+      <field name="description" type="Text" title="Description">
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+      </field>
+      <field name="comments" type="Text" title="Comments">
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+      </field>
+      <field name="name" type="Text" title="Name">
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+      </field>
+    </fields>
+    <relationships/>
+    <data_layouts>
+      <data_layout name="list" parent_table="props">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="prop_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="details" parent_table="props">
+        <data_layout_groups>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="prop_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
+    <reports/>
+    <print_layouts/>
+  </table>
   <table name="scene_cast" hidden="true" title="Scene Cast">
     <example_rows>
       <example_row>
@@ -2627,29 +2765,35 @@
     </trans_set>
     <fields>
       <field name="scene_cast_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Cast ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Szene Besetzung ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="cast_id" type="Number" title="Cast ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="cast" choices_related_field="character_id" choices_related_second="character"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="cast" choices_related_field="character_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="character" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Besetzung ID"/>
         </trans_set>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Szene ID"/>
         </trans_set>
@@ -2674,16 +2818,16 @@
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="scene_cast_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="cast_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2693,18 +2837,18 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <data_layout_item name="scene_cast_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="cast_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
           </data_layout_group>
@@ -2715,27 +2859,106 @@
     <print_layouts/>
   </table>
   <table name="scene_costume" hidden="true" title="Scene Costume">
-    <example_rows/>
+    <example_rows>
+      <example_row>
+        <value column="scene_costume_id">0</value>
+        <value column="comments"/>
+        <value column="scene_id"/>
+        <value column="costume_id">1</value>
+      </example_row>
+      <example_row>
+        <value column="scene_costume_id">1</value>
+        <value column="comments"/>
+        <value column="scene_id">0</value>
+        <value column="costume_id">0</value>
+      </example_row>
+      <example_row>
+        <value column="scene_costume_id">2</value>
+        <value column="comments"/>
+        <value column="scene_id">0</value>
+        <value column="costume_id">1</value>
+      </example_row>
+      <example_row>
+        <value column="scene_costume_id">3</value>
+        <value column="comments"/>
+        <value column="scene_id">0</value>
+        <value column="costume_id">3</value>
+      </example_row>
+    </example_rows>
     <fields>
       <field name="scene_costume_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Costume ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
-      </field>
-      <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="scene_id" type="Number" title="Scene Id">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+      </field>
+      <field name="costume_id" type="Number" title="Costume ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="costume" choices_related_field="costume_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
     </fields>
-    <relationships/>
-    <data_layouts/>
+    <relationships>
+      <relationship name="costume" key="costume_id" other_table="costume" other_key="costume_id" title="Costume"/>
+    </relationships>
+    <data_layouts>
+      <data_layout name="list" parent_table="scene_costume">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="scene_costume_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="details" parent_table="scene_costume">
+        <data_layout_groups>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="scene_costume_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="costume_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="name" relationship="costume" editable="true" use_default_formatting="true">
+              <title_custom use_custom="true" title="Costume Name"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true">
+                <choices_related_extra_layout>
+                  <data_layout_groups>
+                    <data_layout_group/>
+                  </data_layout_groups>
+                </choices_related_extra_layout>
+              </formatting>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
     <reports/>
     <print_layouts/>
   </table>
@@ -2754,29 +2977,45 @@
     </trans_set>
     <fields>
       <field name="scene_crew_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Crew ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Szene Crew ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="scenes" choices_related_field="scene_id" choices_related_second="description"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="scenes" choices_related_field="scene_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="description" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="de_DE" val="Szene ID"/>
         </trans_set>
       </field>
       <field name="department_id" type="Number" title="Department ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="department" choices_related_field="departments_id" choices_related_second="name"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="department" choices_related_field="departments_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
     </fields>
     <relationships>
@@ -2793,11 +3032,11 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
+                <trans loc="de_DE" val="Ãbersicht"/>
                 <trans loc="en_GB" val="Overview"/>
               </trans_set>
               <data_layout_item name="scene_crew_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
@@ -2806,21 +3045,39 @@
                 <trans loc="en_GB" val="Details"/>
               </trans_set>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="department_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name" relationship="department" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
+      <data_layout name="list" parent_table="scene_crew">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="scene_crew_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="department_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
     </data_layouts>
     <reports/>
     <print_layouts/>
@@ -2851,30 +3108,36 @@
     </trans_set>
     <fields>
       <field name="scene_equipment_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Equipment ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="en_GB" val="scene_equipment ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
           <trans loc="en_GB" val="Comments"/>
         </trans_set>
       </field>
       <field name="equipment_id" type="Number" title="Equipment ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="equipment" choices_related_field="equipment_id" choices_related_second="description"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="equipment" choices_related_field="equipment_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="description" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
         <trans_set>
           <trans loc="en_GB" val="Equipment ID"/>
         </trans_set>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="en_GB" val="Scene ID"/>
         </trans_set>
@@ -2896,17 +3159,37 @@
       <data_layout name="list" parent_table="scene_equipment">
         <data_layout_groups>
           <data_layout_group name="main">
+            <data_layout_item name="scene_equipment_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="equipment_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="details" parent_table="scene_equipment">
+        <data_layout_groups>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
             <data_layout_item name="scene_equipment_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
-            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
-            <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -2919,24 +3202,29 @@
     <example_rows/>
     <fields>
       <field name="scene_extras_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Extras ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contact" choices_related_field="contact_id" choices_related_second="name_full"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contact" choices_related_field="contact_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name_full" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
     </fields>
     <relationships>
@@ -2948,29 +3236,50 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <data_layout_item name="scene_extras_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="name_full" relationship="contact" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
           </data_layout_group>
         </data_layout_groups>
       </data_layout>
+      <data_layout name="list" parent_table="scene_extras">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="scene_extras_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
     </data_layouts>
     <reports/>
     <print_layouts/>
@@ -2979,49 +3288,144 @@
     <example_rows/>
     <fields>
       <field name="scene_makeup_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Makeup ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
     </fields>
     <relationships/>
-    <data_layouts/>
+    <data_layouts>
+      <data_layout name="list" parent_table="scene_makeup">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="scene_makeup_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="details" parent_table="scene_makeup">
+        <data_layout_groups>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="scene_makeup_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
     <reports/>
     <print_layouts/>
   </table>
   <table name="scene_props" hidden="true" title="Scene Props">
-    <example_rows/>
+    <example_rows>
+      <example_row>
+        <value column="scene_props_id">0</value>
+        <value column="comments"/>
+        <value column="scene_id">0</value>
+        <value column="prop_id">0</value>
+      </example_row>
+      <example_row>
+        <value column="scene_props_id">1</value>
+        <value column="comments"/>
+        <value column="scene_id">0</value>
+        <value column="prop_id">1</value>
+      </example_row>
+      <example_row>
+        <value column="scene_props_id">2</value>
+        <value column="comments"/>
+        <value column="scene_id">0</value>
+        <value column="prop_id">2</value>
+      </example_row>
+    </example_rows>
     <fields>
-      <field name="scene_props_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Props ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
-      </field>
-      <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+      <field name="scene_props_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Prop ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+      </field>
+      <field name="prop_id" type="Number" title="Prop ID">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="props" choices_related_field="prop_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
     </fields>
-    <relationships/>
-    <data_layouts/>
+    <relationships>
+      <relationship name="props" key="prop_id" other_table="props" other_key="prop_id" title="Props"/>
+    </relationships>
+    <data_layouts>
+      <data_layout name="list" parent_table="scene_props">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="scene_props_id" editable="true" use_default_formatting="true" column_width="40">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true" column_width="103">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="details" parent_table="scene_props">
+        <data_layout_groups>
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <data_layout_item name="scene_props_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
     <reports/>
     <print_layouts/>
   </table>
@@ -3064,54 +3468,56 @@
     </trans_set>
     <fields>
       <field name="scene_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Szene ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="location_id" type="Number" title="Location ID">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="location" choices_related_field="location_id" choices_related_second="name"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="location" choices_related_field="location_id" choices_related_show_all="true">
+          <choices_related_extra_layout>
+            <data_layout_groups>
+              <data_layout_group>
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+              </data_layout_group>
+            </data_layout_groups>
+          </choices_related_extra_layout>
+        </formatting>
       </field>
       <field name="date" type="Date" title="Date">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Termin"/>
         </trans_set>
       </field>
       <field name="time" type="Time" title="Time">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Zeit"/>
         </trans_set>
       </field>
       <field name="minutes" type="Number" title="Stop (minutes)">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Stunde"/>
         </trans_set>
       </field>
       <field name="day_or_night" type="Text" title="Day/Night">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6" choices_related_show_all="true">
           <custom_choice_list>
             <custom_choice value="Nacht"/>
             <custom_choice value="Tag"/>
@@ -3125,8 +3531,7 @@
         </trans_set>
       </field>
       <field name="interior_or_exterior" type="Text" title="Interior/Exterior">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6" choices_related_show_all="true">
           <custom_choice_list>
             <custom_choice value="Interior"/>
             <custom_choice value="Exterior"/>
@@ -3137,8 +3542,7 @@
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Szene"/>
         </trans_set>
@@ -3149,15 +3553,13 @@
 else:
     return record.related["location"]["name"]
 </calculation>
-        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
       </field>
       <field name="pages" type="Number" title="Pages">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
       <field name="script_day" type="Number" title="Script Day">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
       </field>
     </fields>
     <relationships>
@@ -3185,167 +3587,171 @@ else:
       </relationship>
       <relationship name="scene_extras" key="scene_id" other_table="scene_extras" other_key="scene_id" auto_create="true" allow_edit="true" title="Extras"/>
       <relationship name="scene_props" key="scene_id" other_table="scene_props" other_key="scene_id" auto_create="true" allow_edit="true" title="Props"/>
-      <relationship name="scene_costume" key="scene_id" other_table="scene_costume" auto_create="true" allow_edit="true" title="Costume"/>
+      <relationship name="scene_costume" key="scene_id" other_table="scene_costume" other_key="scene_id" auto_create="true" allow_edit="true" title="Costume"/>
       <relationship name="scene_makeup" key="scene_id" other_table="scene_makeup" other_key="scene_id" auto_create="true" allow_edit="true" title="Additional Makeup"/>
     </relationships>
     <data_layouts>
       <data_layout name="details" parent_table="scenes">
         <data_layout_groups>
-          <data_layout_group name="main">
-            <data_layout_group name="overview" columns_count="2" title="Overview">
+          <data_layout_group name="overview" columns_count="2" title="Overview">
+            <trans_set>
+              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="en_GB" val="Overview"/>
+            </trans_set>
+            <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="overview_name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="minutes" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="script_day" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+          </data_layout_group>
+          <data_layout_group name="details" columns_count="2" title="Details">
+            <trans_set>
+              <trans loc="de_DE" val="Details"/>
+              <trans loc="en_GB" val="Details"/>
+            </trans_set>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_text>
+              <text title="The location name will be used if the name is empty."/>
+              <formatting/>
+            </data_layout_text>
+            <data_layout_group name="scenario" title="Scenario">
               <trans_set>
-                <trans loc="de_DE" val="&#xDC;bersicht"/>
-                <trans loc="en_GB" val="Overview"/>
+                <trans loc="de_DE" val="Stimmung"/>
               </trans_set>
-              <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </data_layout_item>
-              <data_layout_item name="overview_name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-              </data_layout_item>
-              <data_layout_item name="minutes" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <data_layout_item name="interior_or_exterior" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="script_day" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <data_layout_item name="day_or_night" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_group>
-            <data_layout_group name="details" columns_count="2" title="Details">
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="pages" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_item name="date" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+            </data_layout_item>
+            <data_layout_group name="location" title="Location">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
-                <trans loc="en_GB" val="Details"/>
+                <trans loc="de_DE" val="Location"/>
+                <trans loc="en_GB" val="Location"/>
               </trans_set>
-              <data_layout_item name="name" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="location_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_text>
-                <formatting/>
-                <text title="The location name will be used if the name is empty."/>
-              </data_layout_text>
-              <data_layout_group name="scenario" title="Scenario">
-                <trans_set>
-                  <trans loc="de_DE" val="Stimmung"/>
-                </trans_set>
-                <data_layout_item name="interior_or_exterior" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="day_or_night" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
-              <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_item name="name" relationship="location" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="pages" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <data_layout_item name="name_full" relationship="location" related_relationship="contacts" editable="true" use_default_formatting="true">
+                <title_custom use_custom="true" title="Contact Name"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_item name="date" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <data_layout_item name="address_street" relationship="location" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_town" relationship="location" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+              </data_layout_item>
+              <data_layout_item name="address_postcode" relationship="location" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
-              <data_layout_group name="location" title="Location">
-                <trans_set>
-                  <trans loc="de_DE" val="Location"/>
-                  <trans loc="en_GB" val="Location"/>
-                </trans_set>
-                <data_layout_item name="location_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
-                <data_layout_item name="name" relationship="location" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="name_full" relationship="location" related_relationship="contacts" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                  <title_custom use_custom="true" title="Contact Name"/>
-                </data_layout_item>
-                <data_layout_item name="address_street" relationship="location" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_town" relationship="location" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-                <data_layout_item name="address_postcode" relationship="location" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
-              </data_layout_group>
             </data_layout_group>
           </data_layout_group>
           <data_layout_group name="details_lower">
             <data_layout_notebook name="notebook">
-              <data_layout_portal relationship="scene_cast">
+              <data_layout_portal relationship="scene_cast" portal_rows_count="6">
                 <data_layout_item name="cast_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="character" relationship="cast" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="name_full" relationship="cast" related_relationship="contacts_actor" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
                   <title_custom use_custom="true" title="Actor's Name"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
-              <data_layout_portal relationship="scene_extras">
-                <data_layout_item name="description" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
-                </data_layout_item>
+              <data_layout_portal relationship="scene_extras" portal_rows_count="6" column_line_color="#000000000000" line_color="#000000000000">
                 <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="name_full" relationship="contact" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="103">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
-              <data_layout_portal relationship="scene_props">
-                <data_layout_item name="description" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_portal relationship="scene_props" portal_rows_count="6" column_line_color="#000000000000" line_color="#000000000000">
+                <data_layout_item name="prop_id" editable="true" use_default_formatting="true" column_width="40">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="props" editable="true" use_default_formatting="true" column_width="103">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
-              <data_layout_portal relationship="scene_costume">
-                <data_layout_item name="description" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <data_layout_portal relationship="scene_costume" portal_rows_count="6" column_line_color="#000000000000" line_color="#000000000000">
+                <data_layout_item name="costume_id" editable="true" use_default_formatting="true" column_width="40">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="costume" editable="true" use_default_formatting="true" column_width="103">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
-              <data_layout_portal relationship="scene_crew">
+              <data_layout_portal relationship="scene_crew" portal_rows_count="6">
                 <data_layout_item name="department_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="name" relationship="department" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
-              <data_layout_portal relationship="scene_equipment">
+              <data_layout_portal relationship="scene_equipment" portal_rows_count="6">
                 <data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="description" relationship="equipment" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
-              <data_layout_portal relationship="scene_makeup">
+              <data_layout_portal relationship="scene_makeup" portal_rows_count="6">
                 <data_layout_item name="description" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
                 <data_layout_item name="comments" editable="true" use_default_formatting="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
                 </data_layout_item>
               </data_layout_portal>
             </data_layout_notebook>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -3354,25 +3760,25 @@ else:
         <data_layout_groups>
           <data_layout_group name="main">
             <data_layout_item name="scene_id" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="overview_name" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="interior_or_exterior" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="day_or_night" editable="true" use_default_formatting="true" column_width="143">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="date" editable="true" use_default_formatting="true" column_width="77">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="minutes" editable="true" use_default_formatting="true" column_width="90">
-              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
             </data_layout_item>
             <data_layout_item name="description" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -3387,7 +3793,7 @@ else:
               <formatting/>
             </data_layout_item>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
-              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
             </data_layout_item>
           </data_layout_group>
         </data_layout_groups>
@@ -3398,25 +3804,21 @@ else:
         <data_layout_groups>
           <data_layout_group>
             <data_layout_item_groupby>
-              <groupby name="date" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
-              </groupby>
+              <groupby name="date" editable="true" use_default_formatting="true"/>
               <sortby>
-                <data_layout_item name="time" editable="true" use_default_formatting="true" sort_ascending="true">
-                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
-                </data_layout_item>
+                <data_layout_item name="time" editable="true" use_default_formatting="true" sort_ascending="true"/>
               </sortby>
               <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="interior_or_exterior" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="day_or_night" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
               <data_layout_item name="description" editable="true" use_default_formatting="true">
-                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" choices_related_show_all="true"/>
               </data_layout_item>
             </data_layout_item_groupby>
           </data_layout_group>
@@ -3436,8 +3838,7 @@ else:
     </trans_set>
     <fields>
       <field name="teams_id" primary_key="true" unique="true" auto_increment="true" type="Number">
-        <calculation/>
-        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related_show_all="true"/>
         <trans_set>
           <trans loc="de_DE" val="Teams ID"/>
         </trans_set>



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]