| Re: Search when some columns are dropdown lists [message #540 is a reply to message #517] |
Fri, 12 January 2007 18:17   |
David Lee
Messages: 44
Registered: June 2006
|
Member |
|
|
Point #1 was just making the two fields the same name - it does not matter if they are both "location_id" or "fklocation_id"
However, I have finally realised what you were saying, and/or how to overcome this problem. It requires two small, matching changes:
1) In the data dictionary for the main table, column fklocation_id, the name of the option list should be fklocation_id, not location_id. The updated structure needs exporting to PHP after changing.
2) In the cm_getExtraData routine of the main table, the name of the key for the required array should be fklocation_id, not location_id
Having made those changes, the search dropdown list have the extra entry of "undefined"
Thanks for your help, Tony, and I hope this thread saves someone else some time!
David Lee
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
