Let's say I have a Customer master table, and a Sales detail table. When adding a new sale, the first field is a dropdown to select the customer. The Link field is CustomerID, the display field is CustomerName. After the user selects the customer, I would like to have a link to edit the customer similar to the Add New that is built in. It would pop up a window that would allow the user to edit Customer information (such as address) prior to adding the Sales record. I tried by adding a code snippet like this:
echo "<a href=tblcustomers_edit.php?editid1=". $data["CustomerID"].">Edit Customer</a>";
either my syntax is wrong, or the CustomerID doesn't get loaded, because the query string is empty.
thanks for any help!