Multiple Table Question

I've created a dashboard built from Chronoforms where the enduser enters various different information and then they continue on to set two, then step three, etc. Each step saves in a different table with a total of 5 tables. The last just captures when they submit which I want as my primary table in ChronoConnectivity. That way it only shows a record on the frontend when the client has submitted all data.

I'm trying to figure out how to get the data to populate from the other tables. In the multi table settings each table has been setup and it's populating all the fields for each table in the auto loader section (so the tables are connected correctly) But when I try to create my own template when I put a field ex. {grandtotal} no information is populated from the budget7 table.

Any idea, solutions as how to make this work?

maybe model ID has something to do with your problem ?

Just my guess

Michele

I'm new to all this. How is the model ID used? Currently it is empty.

Hi,

The Model ID is the table alias and is vital when working with more than 1 table in your connection, do you have foreign keys in your tables associating the records together ? please post here SQL export for your tables structures so we can check if the relations are correct or not.

Regards,
Max

Hey Max,

The tables are not tied together in MySQL but the records in each table do have the same cf_user_id.

I'm working with a total of 5 tables.

Tables Being Used:
u6tdn_finalstep (Primary Table)
members_signup
u6tdn_budgetpage7
u6tdn_creditmonitoring
u6tdn_tradelines

Here are the syntaxes for each table

CREATE TABLE `u6tdn_finalstep` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_uid` varchar(255) DEFAULT NULL,
  `cf_created` datetime DEFAULT NULL,
  `cf_modified` datetime DEFAULT NULL,
  `cf_ipaddress` varchar(255) DEFAULT NULL,
  `cf_user_id` varchar(255) DEFAULT NULL,
  `input_submit_2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

CREATE TABLE `members_signup` (
  `plan` varchar(15) NOT NULL,
  `FirstName` varchar(100) NOT NULL,
  `LastName` varchar(100) NOT NULL,
  `Street` varchar(100) NOT NULL,
  `City` varchar(100) NOT NULL,
  `State` varchar(100) NOT NULL,
  `Zip` varchar(5) NOT NULL,
  `Phone` varchar(15) NOT NULL,
  `AltPhone` varchar(15) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `CoFirstName` varchar(100) NOT NULL,
  `CoLastName` varchar(100) NOT NULL,
  `CoStreet` varchar(100) NOT NULL,
  `CoCity` varchar(100) NOT NULL,
  `CoState` varchar(100) NOT NULL,
  `CoZip` varchar(10) NOT NULL,
  `CoPhone` varchar(15) NOT NULL,
  `CoAltPhone` varchar(15) NOT NULL,
  `CoEmail` varchar(100) NOT NULL,
  `Package` varchar(100) NOT NULL,
  `BankName` varchar(100) NOT NULL,
  `RoutingNumber` varchar(20) NOT NULL,
  `AccountNumber` varchar(20) NOT NULL,
  `AccountName` varchar(20) NOT NULL,
  `PostPayment` varchar(50) NOT NULL,
  `ReferralCode` varchar(100) NOT NULL,
  `agree1` varchar(10) NOT NULL,
  `agree2` varchar(10) NOT NULL,
  `SSN` varchar(4) NOT NULL,
  `cf_created` datetime NOT NULL,
  `id` int(3) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=261 DEFAULT CHARSET=latin1;

CREATE TABLE `u6tdn_budgetpage7` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_uid` varchar(255) DEFAULT NULL,
  `cf_created` datetime DEFAULT NULL,
  `cf_modified` datetime DEFAULT NULL,
  `cf_ipaddress` varchar(255) DEFAULT NULL,
  `cf_user_id` varchar(255) DEFAULT NULL,
  `spendable` varchar(255) DEFAULT NULL,
  `housetotal` varchar(255) DEFAULT NULL,
  `cartotal` varchar(255) DEFAULT NULL,
  `creditortotal` varchar(255) DEFAULT NULL,
  `misctotal` varchar(255) DEFAULT NULL,
  `grandtotal` varchar(255) DEFAULT NULL,
  `expensetotal` varchar(255) DEFAULT NULL,
  `back` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

CREATE TABLE `u6tdn_creditmonitoring` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_uid` varchar(255) DEFAULT NULL,
  `cf_created` datetime DEFAULT NULL,
  `cf_modified` datetime DEFAULT NULL,
  `cf_ipaddress` varchar(255) DEFAULT NULL,
  `cf_user_id` varchar(255) DEFAULT NULL,
  `ficologin` varchar(255) DEFAULT NULL,
  `ficopassword` varchar(255) DEFAULT NULL,
  `input_submit_2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

CREATE TABLE `u6tdn_tradelines` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_uid` varchar(255) DEFAULT NULL,
  `cf_created` datetime DEFAULT NULL,
  `cf_modified` datetime DEFAULT NULL,
  `cf_ipaddress` varchar(255) DEFAULT NULL,
  `cf_user_id` varchar(255) DEFAULT NULL,
  `revtradeline` varchar(255) DEFAULT NULL,
  `instradeline` varchar(255) DEFAULT NULL,
  `input_submit_3` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

It's not enough to associate records using the cf_user_id if you have more than 1 record for the same user, you must have 1 column in each table to identify the relationship to a record in the parent table.

What's the main table in this process ?

Regards,
Max

The main table is u6tdn_finalstep. We don't want any information to be visible until the last step in completed. This would be this table. So no info is put into this table until the last step and they hit submit.

So the data is pushed into all tables after the last step ? if yes then which table is receiving the data first ? if every table is associated to a form step then the main table should be the table of the first page, and the id of the stored record should be added to the other tables under a new column called "main_id" for example.

Why do you store each step data in its own table ?

Regards,
Max