Radicore Forum: How To » Search when some columns are dropdown lists

Home » RADICORE » How To » Search when some columns are dropdown lists

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Search when some columns are dropdown lists [message #536 is a reply to message #534]

Wed, 10 January 2007 18:13

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

No, the foreign key names do not *have* to be the same as the primary key names, but my convention is to keep them the same wherever possible.

What I am saying is that to avoid the problem you encountered the lookup array should have the same name as the field in which it will be displayed. So if the field is called 'fklocation_id' the lookup array should also be called 'fklocation_id' and not 'location_id'. The easiest way for the framework to associate a lookup array with a field is if they have the exact same name.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Search when some columns are dropdown lists By: David Lee on Mon, 01 January 2007 05:00
		Re: Search when some columns are dropdown lists By: AJM on Mon, 01 January 2007 05:48
		Re: Search when some columns are dropdown lists By: David Lee on Wed, 10 January 2007 12:03
		Re: Search when some columns are dropdown lists By: AJM on Wed, 10 January 2007 12:28
		Re: Search when some columns are dropdown lists By: David Lee on Wed, 10 January 2007 15:32
		Re: Search when some columns are dropdown lists By: AJM on Wed, 10 January 2007 16:10
		Re: Search when some columns are dropdown lists By: David Lee on Wed, 10 January 2007 17:01
		Re: Search when some columns are dropdown lists By: AJM on Wed, 10 January 2007 18:13
		Re: Search when some columns are dropdown lists By: David Lee on Thu, 11 January 2007 14:06
		Re: Search when some columns are dropdown lists By: AJM on Thu, 11 January 2007 14:40
		Re: Search when some columns are dropdown lists By: David Lee on Fri, 12 January 2007 18:17
		Re: Search when some columns are dropdown lists By: AJM on Sat, 13 January 2007 05:13

Previous Topic:	List with pre-defined search active
Next Topic:	flexible approach

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 09 07:33:49 EDT 2025

Total time taken to generate the page: 0.01199 seconds