One-to-One relation Record

Quote wkempees:

A Record Form so you want to update both tables as well?
Displaying data from two 1on1 tables is as easy as joining them in the VQB.
Am sure you know how.
Select a.fields, b.fields from table1 as a, table2 as b
where 1.id = b.id

Update 2 tables at one (specially Insert) through Custom
Insert/Update/Delete
or using te MultiPage Record Form example.

Quote wkempees:

Views are Views....
Your Record form have it work on either a View or a joined 2 tables.
In the Custom Insert/Update/Delete handle the main table.
In the AfterInsert/Update/Delete handle the other table.

??

Quote wkempees:

> Views are Views....
> Your Record form have it work on either a View or a joined 2 tables.
> In the Custom Insert/Update/Delete handle the main table.
> In the AfterInsert/Update/Delete handle the other table.
>
> ??

Quote wkempees:

Thanks for the smiley but what about the "No"?
Need anything more?

Quote wkempees:

> Thanks for the smiley but what about the "No"?
> Need anything more?
>

Quote wkempees:

So, you're back then

What is your exact problem, which of the following 2 is completed:
1: the RecordForm is displaying and the data from both related tables is correctly displayed.
2: The RecordForm accepts updates to fields from Both table 1 and 2, but Insert/Update/Delete does not work

Xtra:
Delete, using CustomDelete, identifying primary key item on table 1 will correctly delete the record.
So in AfterExecuteDelete, Row from Table1 is deleted, you need to pickup the primary key value for table2 and execute ans sql statement like:
$sql = 'Delete from Table2 where keyfield=' . $saved_value;

  
  
$db = new clsDB<name of your connection>;  
$db->open();  
  
$sql='.........';  
  
&db->query($sql);  
$db->close();  

  
  
For the Delete:  
$sql = 'DELETE from <table2name> WHERE <primarykeyfieldtable2name> =' . CCGetFromGet('id','');  
  
assuming the URL is something like ?id=12345  
otherwise adjust the fieldname or use a CCGetFromPost('fieldname')  
where 'fieldname'is the identifying field.  
  
For the Update:  
$sql = 'UPDATE  <table2name> '  
         . ' SET 'fieldname1 ='. $db->ToSQL(  $Component->fieldname1->GetValue() , TYPE ) '  
         . ',  fieldname2=' . $db->ToSQL( $Component->fieldname2->GetValue() , TYPE ) '  
         . ' WHERE <primarykeyfieldname> =' . CCGetFromGet('id','');  
  
The TYPE needs to be replaced with the appropriate ccsDate, ccsBoolean, ccsInteger, ccsFloat, ccsText, ccsMemo depending on the data fields type  (read Helpfile: ToSQL) CCS will do proper convert for you depending on various settings you set in Connections.  
  
So what remains is the INSERT