insert with no recordset
i am confused on how the insert works in datassist. there is no recordset defined (at least not showing in the DW behaviors screen).
My structure is a dealer_tbl with a joined table called inventory_tbl ( i think it is a left joined but not sure).
I want to insert a new record into the inventory_table but i need some data from the dealer_tbl. If i were making a recordset, i would join them and it is easy enough. but i dont understand the DA insert record. do i just make a recordset and insert to it, or do i need to create a session variable when they log in? or can i modify the following code to be a JOIN?
be prepared for me to ask a couple of follow up questions :)
thanks
<?php
// WA Application Builder Insert
if (isset($_POST["Insert_x"])) // Trigger
{
$WA_connection = $Auto_Sales;
$WA_table = "inventory_tbl";
$WA_sessionName = "WADA_Insert_inventory_tbl";
$WA_redirectURL = "";
if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";
$WA_keepQueryString = false;
$WA_indexField = "Inventory_ID";
$WA_fieldNamesStr = "Dealer_Name|Price|Make|Model|Year|Engine|Drivetrain|Transmission|Mileage|Ext_Color|Int_Color|Body_Style|VIN|Stock_Number|Description|Date_Online|Expires|pwr_windows|pwr_locks|rear_slider|DVD|3rd_seat|premium_sound|leather|bed_liner|premium_wheels|Dealer_TBL_Dealer_ID|Status|City|Contact_Phone";