Autofill two fields in 1 from one table to another

PHPMaker General Discussion (PHPMaker)
1

hi i am new to phpmaker i am in my trial version and doing a practice

I need to autocomplete two fields from my database into 1 field from another

table example

Table 1

|Name | lastname1 | lastname2|
±--------|---------------|---------------+
|jhon ---- | smith ---- |—obama |
±--------------------------------------------+

table2

|Name | surnames |
±--------|-----------------+
|jhon— | smith obama|
±---------------------------+

(surname1 + surname) <----- taking the two data from table 1 surname1 and surname2 and with complete autocomplete the surname field of my table2

I don’t know how to do it since in the fields —> loockup —> autocomplete —> source field … it only allows one table field


that I need when selecting the name the last names are the autocomplete last name from table1 to table2

table2 <------- with AutoComplete

|Name | surnames |
±--------|-----------------+ autofill surnames
|jhon | smith obama|
±---------------------------+

2

You may simply use “Row_Inserted” server event that belongs to “table1” instead, in order to concanate the values from “lastname1” and “lastname1” fields:

$surnames = $rsnew[“lastname1”] . " ". $rsnew[“lastname2”];
Execute(“INSERT INTO table2(Name, surnames) VALUES ('” . $rsnew[“Name”] . “', '” . $surnames . “')”);

3

I SOLVED IT, THANKS