| Re: Search when some columns are dropdown lists [message #526 is a reply to message #517] |
Wed, 10 January 2007 12:03   |
David Lee
Messages: 44
Registered: June 2006
|
Member |
|
|
Having finally installed a debugger and found some more time, in file include.xml.php4.inc at line 302, array_key_exists($field, $fieldspec) evaluates as false, skipping the add blank entry code!
The reason is that my lookup table has the key location_id, but the main table field is fklocation_id.
This practice of prefixing foreign table indexes with fk comes from using the QSEE-Superlite program, which I, being a novice in the database world, found very useful for creating the entity relationship diagrams, and then the database structure from those diagrams.
To solve this problem, the first need is to confirm is Radicore should work with this naming convention, or if this breaks the design rules.
That should be easy for you to confirm, Tony!
Regards
David Lee
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
