2. PHPRunner General questions
  3. [SOLVED]  Updating a linked Table
This topic is locked
[SOLVED]

 Updating a linked Table

 		10/23/2013 3:28:02 PM
PHPRunner General questions
C
 CWDATA author

Ok I know this is standard stuff and I have done it before but at this point in time I have an update that just is not working in two separate instances.
I have a table "tblworklistV2" which contains all but one of the fields relating to a given record. I have a second table (child) "tblworklistnotesV2" that contains a notes field. The Primary Key in the Master Table is ID and the Primary Key in the Child Table is Index whilst the other two fields are ID and Notes.

The join fields between the two Tables are ID.

What I need to do is when the user adds a new record in "tblworklistV2", the ID number against that record is "inserted" into the ID Field of the "tblworklistnotesV2".

I have been through the manual for PHPRunner and tried everything in there but just doesn't work.

It maybe I can't see wood for the trees so any help would be appreciated.

Carl.
Sergey Kornilov admin 10/23/2013

You need to explain what exactly you have tried (post your code) and what didn't work (error messages if any). Just not clear what sort of help you looking for here.
C
 		CWDATA author 10/23/2013



You need to explain what exactly you have tried (post your code) and what didn't work (error messages if any). Just not clear what sort of help you looking for here.



I have explained what I want to do.

I have tried solutions in 6.2 Manual although I am using 7.0
Sergey Kornilov admin 10/23/2013

Sorry, this just don't make any sense. There is not enough info. All I understand is that you tried "something" and "something" didn't work.