custom field - lookup from another table

PHPMaker General Discussion (PHPMaker)
1

Hi,

Can you please help me bring a lookup value to a custom field ?
The idea is to have a custom field on a certain table with a relative value from another table.
Something like SELECT foreign_field FROM another_table WHERE another_table!id = $this->id->CurrentValue

Thank you

2

Just setup your Custom Field like another normal field that uses “Lookup Table”. You may also add your “Filter” string from “Lookup Selecting” server event for that Custom Field.

Please read “Server Events and Client Scripts” topic from PHPMaker Help menu for more info and example.