Forums

Hello,
my form stores records on in 2 tables.
The first table is the main table.
In the second table are multiple records that belong to a main data set stored.
This works (sceen).
From the form I made a copy to edit data later.
The data from the main table are displayed correctly in my Edit-form and may be changed.
The data of Table 2 do not appear to me. What is the problem?
Settings for DB Read for Table 2 in Setup:
Activate Assignment: yes
Model: Firma_1
Table: name_2.Tabelle
Type: hasMany
Foreign Key: id_firma
Join Condition: empty

In addition, many are me "multiplier container" appears on the form tab, although 2 of these "multiplier container" only have Content (screen1).

Hi,

back a little further.
The 2 read db actions load the array (screen)
What do I still lack is that the data stored in the second table in the database data is displayed in my Edit form.
The data of Table 1 are shown, only the corresponding records in the 2nd table does not (screen1).
What do I need for this?

F.

Hi Fredolino,

What MySQL queries are being created by the DB Read actions - I can see that the first one is giving you data from one table. What is the second query?

Bob

Hi Bob,

now I'm a little step further.
The data from the two tables appear to me in the Edit form.
The data from the first table model "company" can I modify and save.
The data from the second table are shown me, but I can not change them.
Currently I'm using the "Setup" On load these settings:
DB Read Table 1: (screen = base screen1 = ratio)
Read DB 2. Table: (Screen2 = base, screen3 = ratio)
In the DB table are the records that are associated with the main table, stored correctly (screen4).
But the assignment of the data in the DB Read actions are wrong (screen5)?

F.

Hi Fredelino,

I'm still confused - you now seem to have two DB Read actions loading the same data from the second table.

If you are using the Relations to join the data there does seem to be a problem with the ChronoForms code - I posted a workaround for that in another thread here yesterday.

Bob

OK,
I have disabled the conditions in the DB Read 2 actions.
There are both my records from the 2nd table in the Edit form appears, although only one record is displayed in the debugger in the DB Read (Firma_1).

Hi Fredolino,

So you have two queries? Do they give you any results?? You haven't' posted that part of the debugger output.

Please copy and paste the debugger text not screenshots.- the text is much easier to read.

Bob

I have 2 DB read-actions
1. db Read for Table one (Main-table)
2. db Read for Table to

Array
(
    [cont] => lists
    [ccname] => connect_unternehmen
    [act] => edit
    [gcb] => 419
    [Firma] => Array
        (
            [id] => 419
            [uniq_id] => c2c59d5b63ac74d0af3492c6d9270f780c7bed1f
            [user_id] => 549
            [created] => 30.01.2016 - 17:24
            [modified] => 
            [firma] => Firmenname neu
            [niederlassung] => 
            [plz] => 
            [ort] => 
            [ortsteil] => 
            [strasse] => 
            [firmentyp] => Interessent
            [branche] => IT / Software
            [anrede] => Sehr geehrte Damen und Herren
            [telefon] => 
            [mobil] => 
            [email] => firma@firma.de
            [fax] => 
            [mailingliste] => 
            [agb_dat] => 
            [vertrag] => 
            [newsletter] => 
            [rabatt] => 
            [AP_anrede] => Frau
            [AP_vorname] => 
            [AP_nachname] => 
            [AP_email] => 
            [AP_telefon] => 
            [AP_mobil] => 
            [AP_fax] => 
            [AP_position] => 
            [AP2_anrede] => Frau
            [AP2_vorname] => 
            [AP2_nachname] => 
            [AP2_email] => 
            [AP2_telefon] => 
            [AP2_mobil] => 
            [AP2_fax] => 
            [AP2_position] => 
            [AP3_anrede] => Frau
            [AP3_vorname] => 
            [AP3_nachname] => 
            [AP3_email] => 
            [AP3_telefon] => 
            [AP3_mobil] => 
            [AP3_fax] => 
            [AP3_position] => 
        )

    [Firma_1] => Array
        (
            [0] => Array
                (
                    [id_auftrag] => 316
                    [id_firma] => 419
                    [position] => Spedition
                    [spezifikation] => schrubber
                    [status] => ARB
                    [provision] => 4.000
                    [bemerkung] => 
                    [wiedervorlage] => 
                    [notizen] => 
                )

            [1] => Array
                (
                    [id_auftrag] => 315
                    [id_firma] => 419
                    [position] => Empfang
                    [spezifikation] => spezi
                    [status] => EIN
                    [provision] => 3.000
                    [bemerkung] => 
                    [wiedervorlage] => 
                    [notizen] => 
                )

        )

)

Array
(
    [35] => Array
        (
            [DB Read] => Array
                (
                    [Queries] => Array
                        (
                            [0] => SELECT `Firma`.`id` AS `Firma.id`, `Firma`.`uniq_id` AS `Firma.uniq_id`, `Firma`.`user_id` AS `Firma.user_id`, `Firma`.`created` AS `Firma.created`, `Firma`.`modified` AS `Firma.modified`, `Firma`.`firma` AS `Firma.firma`, `Firma`.`niederlassung` AS `Firma.niederlassung`, `Firma`.`plz` AS `Firma.plz`, `Firma`.`ort` AS `Firma.ort`, `Firma`.`ortsteil` AS `Firma.ortsteil`, `Firma`.`strasse` AS `Firma.strasse`, `Firma`.`firmentyp` AS `Firma.firmentyp`, `Firma`.`branche` AS `Firma.branche`, `Firma`.`anrede` AS `Firma.anrede`, `Firma`.`telefon` AS `Firma.telefon`, `Firma`.`mobil` AS `Firma.mobil`, `Firma`.`email` AS `Firma.email`, `Firma`.`fax` AS `Firma.fax`, `Firma`.`mailingliste` AS `Firma.mailingliste`, `Firma`.`agb_dat` AS `Firma.agb_dat`, `Firma`.`vertrag` AS `Firma.vertrag`, `Firma`.`newsletter` AS `Firma.newsletter`, `Firma`.`rabatt` AS `Firma.rabatt`, `Firma`.`AP_anrede` AS `Firma.AP_anrede`, `Firma`.`AP_vorname` AS `Firma.AP_vorname`, `Firma`.`AP_nachname` AS `Firma.AP_nachname`, `Firma`.`AP_email` AS `Firma.AP_email`, `Firma`.`AP_telefon` AS `Firma.AP_telefon`, `Firma`.`AP_mobil` AS `Firma.AP_mobil`, `Firma`.`AP_fax` AS `Firma.AP_fax`, `Firma`.`AP_position` AS `Firma.AP_position`, `Firma`.`AP2_anrede` AS `Firma.AP2_anrede`, `Firma`.`AP2_vorname` AS `Firma.AP2_vorname`, `Firma`.`AP2_nachname` AS `Firma.AP2_nachname`, `Firma`.`AP2_email` AS `Firma.AP2_email`, `Firma`.`AP2_telefon` AS `Firma.AP2_telefon`, `Firma`.`AP2_mobil` AS `Firma.AP2_mobil`, `Firma`.`AP2_fax` AS `Firma.AP2_fax`, `Firma`.`AP2_position` AS `Firma.AP2_position`, `Firma`.`AP3_anrede` AS `Firma.AP3_anrede`, `Firma`.`AP3_vorname` AS `Firma.AP3_vorname`, `Firma`.`AP3_nachname` AS `Firma.AP3_nachname`, `Firma`.`AP3_email` AS `Firma.AP3_email`, `Firma`.`AP3_telefon` AS `Firma.AP3_telefon`, `Firma`.`AP3_mobil` AS `Firma.AP3_mobil`, `Firma`.`AP3_fax` AS `Firma.AP3_fax`, `Firma`.`AP3_position` AS `Firma.AP3_position` FROM `epg0c_js_job_unternehmen` AS `Firma`
                        )

                )

        )

    [38] => Array
        (
            [DB Read] => Array
                (
                    [Queries] => Array
                        (
                            [0] => SELECT `Firma_1`.`id_auftrag` AS `Firma_1.id_auftrag`, `Firma_1`.`id_firma` AS `Firma_1.id_firma`, `Firma_1`.`position` AS `Firma_1.position`, `Firma_1`.`spezifikation` AS `Firma_1.spezifikation`, `Firma_1`.`status` AS `Firma_1.status`, `Firma_1`.`provision` AS `Firma_1.provision`, `Firma_1`.`bemerkung` AS `Firma_1.bemerkung`, `Firma_1`.`wiedervorlage` AS `Firma_1.wiedervorlage`, `Firma_1`.`notizen` AS `Firma_1.notizen` FROM `epg0c_js_job_unternehmen_auftrag` AS `Firma_1`
                        )

                )

        )

)

Thanx Bob for your help.

Hi Fredolino,

That looks OK. Please post a link to the form so I can take a quick look at what is happening when the data is loading.

Bob