detail table list, button in row, update field in row with value from master table field

It sounds like you're trying to update a field in a detail table based on a value from the master table in PHPRunner, but you're encountering the issue where getMasterRecord() consistently returns the first record of the master table instead of the relevant record for the detail table row you're working with.

Here are a few steps to troubleshoot and possibly resolve your issue:

1. Understanding getMasterRecord(): The getMasterRecord() function is designed to retrieve the record from the master table based on the current context of the detail table. Ensure that you are calling this function in the appropriate context so it knows which master record to return.

   
   

2. Check the Context: Make sure that you are calling getMasterRecord() within the right event or function that has access to the current row's context. For example, if you are trying to use it in a button or an action that is within the detail table, ensure that it is being executed in the right event (like BeforeShowRow or BeforeProcessRow).

   
   

3. Verify Relationships: Double-check that the relationship between your master and detail tables is set up correctly in PHPRunner. Ensure that the linking fields are properly defined and that data is being passed correctly.

   
   

4. Debugging: To troubleshoot further, you can use debugging techniques like:

   • Logging the ID of the current detail record to ensure it matches with the expected master record.
   • Outputting the result of getMasterRecord() to see what it returns at different points in your code.
   
   
   
   

5. Custom Code: If getMasterRecord() continues to not work as expected, you might consider writing custom SQL queries or using the Lookup feature if your data structure allows it. You can perform a manual lookup using the IDs available to you and retrieve the relevant master record data.

   
   

6. Using the Correct Event: Ensure that you are using this in the correct event for the button. If you're placing the button in individual rows, you may want to use the BeforeProcessRow or AfterProcessRow event to ensure you're operating on the right record.

   
   

Here’s a simple example of how you might implement this:

// Assuming you have the detail table's unique ID and a master field that you want to copy
$masterRecord = getMasterRecord();
if($masterRecord) {
 $newValue = $masterRecord['field_name']; // Replace with your actual field name
 $recordId = $data['ID']; // Replace with your actual detail record ID
 // Now update your detail table record 
 // Use your preferred method to update the database, e.g., SQL query or PHPRunner's built-in functions
}
PHPRunner Support and Community: If you still have issues, consider checking PHPRunner's documentation or forums. The community can be quite helpful, and similar issues might have been discussed before.

By following these steps, you should be able to identify the issue and find a suitable solution for updating the field in your detail table based on the master table's data.

I tried all this and other sulutions from geminiAI but not working, I always just get the first record of the table which is master with getMasterRecord(). Lookup will not work since the detail table has not enough info to find the exact master record.

If the button you are putting is in the row (grid) of the child list page, then this works for me when viewing the child list page from the master page:

Server Tab of button:

$record = $button->getMasterRecord();

$sql1 = DB::PrepareSQL("SELECT * FROM MasterTable WHERE PrimaryKey = :1", $record['ID']);

$rs1 = DB::Query($sql1);

$data1 = $rs1->fetchAssoc();

This should return the data from the master table for that specific record. You will have to change "MasterTable" with the table name, "PrimaryKey" with your primary key field, and "ID" with the name of your primary field name.

Unfortunately also this is not working since getMasterRecord() is not outputing the data which is displayed in the master it is always outputing the first row of the table of the master.

This Button (Server code) I have in the row of the detail list page:

$record1 = $button->getMasterRecord();
$sql1 = DB::PrepareSQL("SELECT * FROM appointments WHERE id = :1", $record1['id']);
$rs1 = DB::Query($sql1);
$data1 = $rs1->fetchAssoc();

$datavalues = array();
$datavalues["appointmentId"] = $data1["id"];

$record2 = $button->getCurrentRecord();

$keyvalues = array();
$keyvalues["id"] = $record2["id"];

DB::Update("briefings", $datavalues, $keyvalues);

/// Alternative this is having the same result:

$record1 = $button->getMasterRecord();

$datavalues = array();
$datavalues["appointmentId"] = $record1["id"];

$record2 = $button->getCurrentRecord();

$keyvalues = array();
$keyvalues["id"] = $record2["id"];

DB::Update("briefings", $datavalues, $keyvalues);

I think I understand what you are trying to do. I wrote this:

//Get Master Record ID & Master Data
$record1 = $button->getMasterRecord();

//You Don't Need This If You Just Need Master Record Primary Key
$sql1 = DB::PrepareSQL("SELECT * FROM appointments WHERE id = :1", $record1['id']);
$rs1 = DB::Query($sql1);
$data1 = $rs1->fetchAssoc();

//Get Child Record Data
$record2 = $button->getCurrentRecord();

$data3 = array();
$keyvalues3 = array();
//Taking Master Primary Key & Updating Child Record "AppointmentID" Field With It
$data3["appointmentid"] = $record1["id"];
$keyvalues["id"] = $record2["id"];
DB::Update("briefings", $data3, $keyvalues3 );

If all you need is the master primary key, then you don't need to use the 3 lines of code under "//You Don't Need....."

$record2 will get your child record's primary key.

If all you need to do is update the "appointmentid" field in the child table, with the primary key of the master table, this should work.

Make sure the button is in the grid/row.

Make sure that the child and master tables are connected in the "Tables" section.

Thank you but still I just get the id of the first row of the master table not the id of the displayed row of the master table.

More details:
Master table (appointments) and custom view detail table (briefingToApointments) is connected in Tables over clientId.
This way I display a list, of all briefings of the client of the displayed master, on the master edit view, in a child list.
With a button in each row of the child list (briefingToApointments), I want to write the appointmentId, to the briefing table appointmentId field of the row the button is in, so the briefing is connected to one appointment.
But with all the codes I tried and we have posted here, I just get the id of the first appointment in the appointments table not the displayed appointment date of the master.