We are using Labkey 12.2 and I would like to set up a study template for users without SLQ or Java knowledge.

One thing we would like to have is, if users enter the Personal Identification Number (PID) in the participant dataset, all other datasets automatically insert a new row using this PID.

To insert data from one table into another one I can use the INSERT INTO command and refer via SELECT and FROM to the data. SQL code would be something like:

INSERT INTO Table2
 (client_last_name, client_first_name, taskDescription, category)
 (SELECT clientLastName, clientFirstName, incidentDescription, category
  FROM Table1)

How can I do this using the webinterface ?
Via lookup the existing PID numbers are shown in a drop down list for the according field, but I did not find a way to do a lookup without programming it.

Any help, suggestions, etc. appreciated.

Thanks,
Volker