Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Search when some columns are dropdown lists
Re: Search when some columns are dropdown lists [message #527 is a reply to message #526] Wed, 10 January 2007 12:28 Go to previous messageGo to previous message
AJM is currently offline  AJM
Messages: 2355
Registered: April 2006
Location: Surrey, UK
Senior Member
Radicore does not use any naming convention, such as an 'fk' prefix, to identify foreign keys. A field becomes a foreign key whenever it is used in a relationship regardless of its name, and it can be used in more than one relationship.

The Radicore framework "knows" that a field is a foreign field when the relationship details are entered into the Data Dictionary and exported to the application. This information is then made available in the $child_relations and $parent_relations arrays within the '<table>.dict.inc' file

When you are associating a lookup array with a field it is a good idea to have the lookup name the same as the field name as the code has to determine the field type before being able to add a blank entry to the array.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: List with pre-defined search active
Next Topic: flexible approach
Goto Forum:
  


Current Time: Wed Aug 07 20:14:46 EDT 2024

Total time taken to generate the page: 0.03133 seconds