[glom] Film Manager example: Scenes: Make the Props and Costume tabs work.
- From: Murray Cumming <murrayc src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [glom] Film Manager example: Scenes: Make the Props and Costume tabs work.
- Date: Thu, 6 Oct 2011 12:45:32 +0000 (UTC)
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="Ü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="Ü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="Ü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ä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ü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="Ü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="Ü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ä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="Ü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="Ü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="Ü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="Ü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]