I'm very new to PHPRunner and have a question before I decide to purchase.... I apologize in advance - I realize similar questions have been asked but I have not clearly understood the replies and how to implement.
I have several tables -
tblEmployees with employeeID, jobDescriptionID, jobLocationID, zipCodeID, firstName, etc...
tbljobDescription with jobDescriptionID, jobDescription, comments
tbljobLocation with jobLocationID, locationName, street1, street2, zipCodeID, etc....
tblzipCodeID with zipCodeID, city, state
I'm not seeing an (easy) way to utilize dropdowns to select jobDescriptonID, jobLocationID, zipCodeID from lookups when adding new records. Is this possible with PHPRUnner?
I also want master/detail lookups between location and employees, job description and employees, etc.
Any help greatly appreciated.